VBA or MACRO to copy table into another worksheet

I had this orginally posted in formula category, but maybe Excel Programing /VBA / Macro is much more appropriate.

This might be harder to explain...but I'll try my best.


I need help copying data from one table (tab "Raw Data) to another (Tab "Sheet 1). The tricky part is that sometimes the data isnt the same in regards to column and rows. I tried to color code what needs to go where. Please let me know if there is i need to elaborate some more.