Excel: Merging specific worksheets from different workbooks into a master file

[XDAnalyst]

Hi all,

I'm just starting with VBA, so I would like some help with this task at hand.

I have four Excel files named "C Tier 4", "L Tier 4", "S Tier 4", and "O Tier 4". Within each of these workbooks, there's a tab called "Data" containing information that I need to combine and extract to a master file (another file). Unfortunately, one of the columns in "O Tier 4" is incorrectly placed, so I need to make sure the workbook columns match the name of the master file columns. Also, since I already have the headers on the master file, I would have to combine the data starting on cell A4.

How would I go about creating a button with VBA code to allow me to do that?

Thanks in advance,

XD

[#2]

Hi @XDAnalyst 

I would like to propose you modern solution using Power Query, that is much simpler that VBA

You can go to datatab > get & transform > folder and connect to the path

this link will be helpful for you https://youtu.be/wIFXqd0m4VY

Regards, Faraz Shaikh | Microsoft MVP, MCT, MIE, MOS Master, Excel Expert

If you find the above solution resolved your query don't forget mark as Official/Best Answer & like it to help the other members find it more.