[Aj_old]

Originally Posted by slurpee55

AJ, would your code here

Sheets(2).Rows("1:1").Copy
shm.Cells(1, 1).PasteSpecial xlPasteValues
Application.CutCopyMode = False

require that the sheet have all the possible values for headers in it?

No it don't need them!
It will copy the headers from the first sheet with data, after that it will check for each header in each sheet if it exist in master sheet, if so then the match function will return the column number there this header is, id no, then again using match (but not the exact match) will get the number of the closer header (by name) and insert a new column after it, and name it accordingly.

In the end you get the full list of all possible headers in that workbook and all the data on the master sheet.

[slurpee55]

Way too slick!

[Aj_old]

Originally Posted by slurpee55

Way too slick!

Let's wait for the OP's response. To see if the code does that he needs!