Extracting and Consolidate Raw data from one sheet to another

Hi, I am trying to find a more efficient process to get my huge raw data which I receive into my upload template. Please see attached worksheet.

As you can see I have given a little sample of my raw data. I then have to consolidate it to my Template Tab. I am trying to find a more excel driven process where it can fill all the information instead of me doing it manually. The four categories in the template are highlighted that is when the raw data is eventually goes to. Currently everything is done manually. I am trying find some sort of formula or better a vba code in which the “Upload template” can go into my “Raw data” tab and pick up the necessary information. Can anyone please help.