Copy data from multiple workbooks to one master workbook

Hi all,

Probably the 6324th time this question has been asked BUT:

I have four excel workbooks in a folder. 2 are .xls and other 2 are .xlsm. None of these workbooks have an equal
amount of sheets. My question is if anyone can help me start up in VBA to open these files, copy the sheets to one
masterfile and close the four workbooks.

Any help for a start-up would be appreciated!

Thank you.

6324 ... well, you probably underestimated :-) (by the way - have you used search?)

Try (it is based on a code I am using elsewhere, so some of variables have strange names :-P) in your masterfile:

Please Login or Register  to view this content.

but note that there will be problems if sheets in different source files have the same names - of course you can rename them first - just be aware of it.

Hi Kaper,

Thanks for your effort!

Code seems to work fine but excel stucks and does not respond anymore.

Think I know what bugs here. The .xls files contain macros. When I open a .xls file it asks me to "Enable Content". Do you have a clue how to avoid this?

Thanks