Appending Multiple Workbooks to Master Workbook

[KashLeeC]

I currently have a folder with a varying amount of files in it. In each file is one sheet's worth of data with an unknown amount of rows.

With the master page open, I would like to copy all of the file's single sheets each to a new sheet in the master workbook, renaming the worksheet as the old files name.

Any help would be great guys!

[mancubus]

hi.

http://www.vbaexpress.com/kb/getarticle.php?kb_id=773





edit:
sorry. this is for consolidating all worksheets -having the same data structure- from multiple workbooks into one worksheet.