Copy lots of spreadsheets to one spreadsheet?

I was wondering whether it's possible to write a macro or script to open all files in a folder, and copy the contents of each of those files to paste in another worksheet.

This code will prompt for a folder then combine the workbooks in that folder

Please Login or Register  to view this content.