Merging multiple workbooks (with multiple worksheets) in to one master sheet

Hi Arlette,

Thanks for your reply.

Please see below the files: the individual file will have at least 5 copies (maybe more in future).

I would like the macro to open the files and copy the contents, I am not really fussed if the documents get opened or not. Each folder will be saved in the same drive & folder, but the sub folder will differ from person to person.

I look forward to hearing back from you!

Thanks
Alex