VBA code to merge multiple workbook sheets into master workbook

[Jmiller73]

Hello,

I am performing a survey and each survey is an individual excel workbook within various subfolders under a master folder.
I have a master excel workbook with a mastersheet tab and would like to pull all of the data from each survey workbook into
the "Mastersheet" tab in the destination XLS file. Each of the survey files has a tab named "Data", and I am needing to copy
columns B:E and create a tab in the destination document for each survey that is copied over. I would rather not have to
select each file as they are in multiple folders under a master folder named M:Reports>Surveys
I want to just copy columns B:E in every excel file that has a tab named "Data" into the "Mastersheet" tab that is open in
the destination report.

Thank you

[alansidman]

Administrative Note:

Welcome to the forum.

Unfortunately, this is a duplicate thread, and you are allowed only ONE thread per issue here.

Please see Forum Rule #5 about thread duplication.

I am closing this thread, but you may continue here in the original thread:[https://www.excelforum.com/excel-pro...ml#post5520538[/COLOR]