Excel RSI Project

I basically need a macro or script that can organize information in a certain way. It involves collecting information from a source worksheet and send it to a destination worksheet, in a specific manner. I explained everything in the attached video. The macro is needed because there's just so much data that I need to sift through that it would be a pain if I were to sort them out manually (there's about 20k lines data).