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

[XDAnalyst]

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.

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

Thanks in advance,

XD

 

[RoryA]

Welcome to the MrExcel Message Board!

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at:

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

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...

www.excelforum.com

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

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

www.msofficeforums.com

If you have posted the question at more places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.