VBA to Copy Data from one Workbook to Another by Column Name

Hi everyone. I'm looking for help creating a macro that will look for data in a column based on its header name (i.e. "Site"), and copy and paste it into a new workbook with a Different Header Name (i.e. "Site Name") in potentially a different column order. So essentially the searching and copying and pasting is solely based on the column header name.

I already have code that will create my new "formatted" workbook and set up the new columns, so I just need excel to return to the other "raw" workbook, grab the data, and return to the "formatted" workbook to drop the data into the right column. I am new to VBA and while I can work with macros, I'm not very good at writing code yet.

My overall goal is taking raw data from a workbook and creating a new formatted workbook that always looks the same for import into a database. Is what I have described the best way to do it?? Any help would be greatly appreciated!

Thanks,
James