Find column name and copy used range under header

Hi All,

I'm attempting to copy data from one work book to another. The column names in the header (Row 1) that have the data I want will always be the same, but the column order will be variable. There are many columns in the data sheet but I'm only looking for a few columns out of many.
What I have so far is this:

Please Login or Register  to view this content.

Which will copy the entire column, but I already have specific headers and formatting in the destination workbook, so I only want the variable data in each column to be copied.

What I would normally use copy data out of a column is this:

Please Login or Register  to view this content.

Which is works great when I know which order the columns will be in (Column B for example), which is not the casecurrently.

Any help would be greatly appreciated, thanks!