MasterSheet.xlsm

I have attached a sample macro.

When you start it, you will be asked to identify the file from which you will get the data. Once you select the file, it will be copied across the the Master Sheet tab you are currently on.

Regards,

David



When you reply please make it clear WHO you are responding to by mentioning their name.
If this has been of assistance, please advise. A little thanks goes a long way.
- Please click on the *Add Reputation button at the bottom of helpful responses.
Please mark your thread as SOLVED:
- Click Thread Tools above your first post, select "Mark your thread as Solved".