Pull in data from multiple closed workbooks and append to a single worksheet using VBA

Hi

I have the following code to successfully pull in data from a closed workbook and put that data in a sheet.

My problem is how to amend the code to pull in data from multiple closed workbooks and append each below the other. The code pulls in data from Department1, MasterFile1. There are 10 Departments and 10 MasterFiles. I could simply copy the code 10 times, but feel there must be a more constructive way of doing that.

Any advice will be much appreciated.

Thanks

Please Login or Register  to view this content.

Any thoughts on this?