Extract and Merge Data based on Column Headers

Hi Guys!

I need help on extracting data from different workbooks but will only extract the data based on the column headers. Then will merge all of the extracted data into one file.


For example:

File 1:

Header 1 | Header 2 | Header 3 | Header 4

File 2:
Header 1 | Header 2 | Header 3 | Header 4

In this example I want to merge
"Header 2" from File 1 and "Header 3" from File 2
(There will be more headers to extract/merge so can it be flexible on how many I can set up to extract?)

--Location of column headers might differ on each file but all of the headers can be found in row 1.

Is this possible?

Thank you in advance!