VBA required to merge data from multiple workbooks into one master file

[jamesaplant77]

Good afternoon.

I have a number of files that will be placed into a network file and will all have the same format. There will be a separate tab for the following:

Risks
Assumptions
Issues
Dependencies

These will all be placed in a specified folder each week and I want to be able to take all the data from each of the tabs and place into one master file for analysis. Once each workbooks data has been copied, I want the next workbooks data to be copied into the next empty row and so on.

Sure this has been done a million times before, but any help would be truly appreciated.

Thanks!!!!

 

[Rijnsent]

Hi James,
have you tried the code from Ron de Bruin? https://www.rondebruin.nl/win/s3/win008.htm
It is a good starting point, but will need some tweaking for your specifications.
Cheers,
Koen