VBA to copy data from a file with the same name but from different folder

[Edi110787]

Hello,

I have 150 clients folders (different names) and in every folder i have an excel file with the name "Client" and i want to make a master file with data from all this "Client" files from all the folders.

Thank you

 

[Trevor G]

not a lot of info to work from to provide a solution. Questions:

is the data on a single sheet and where does the data start.
Is the data in a table which is structured the same in all workbooks
Do you want to copy each sheet into a master workbook.
Do you want the data to go below from each workbook to create just one main table.

Can you provide a screen image of one workbook you want the data to be copied from and a screen shot of the Master workbook. There is a built in tool here which can be downloaded to provide a screen of the table layout called XL2BB