Copying data from several excel files

[MrEngineerUK]

Hello. Is it possible to copy data from multiple excel files into one excel file? I have 30 excel files in one folder. Each file has 8 worksheets. I want to copy just one worksheet from each file into one master excel file. Worksheet number 5 to be exact. One slight complication; the worksheets in each excel file have the same name, so somehow need to slightly change the worksheet name as it is copied into the master excel file, maybe using the file name? I want each worksheet from each individual excel file, to be copied into a new worksheet in the master excel file. So the end result, one excel file, 30 worksheets. Is this possible? Would appreciate any hints on how to tackle this problem. It would save me so much time from doing it manually. Thanks in advance for any assistance.

 

[shadow12345]

maybe use the tools the Ron De Bruin made? its free.

http://www.rondebruin.nl/merge.htm

( I got this website from the microsoft website here)
http://msdn.microsoft.com/en-us/lib...aFromMultipleWorkbooks_MergingRangewithFilter

 

[MrEngineerUK]

Thanks very much for the suggestions. While it doesn't give me exactly what I wanted as it puts all the data from the separate files in one worksheet, I can still use the data so for now it will keep me going. Thanks a lot!