copy multiple excel files in a workbook as sheets

[bmeghana]

Hi,
I need to copy individual excel files and create a single workbook with each file as a worksheet tab. the original files have only one worksheet each.
Is there any way to automate this process, since I need to do this on a weekly basis with around 20 files? If this has already been discussed, can anyone please guide me there. I wasn't able to find any threads which discussed combining files into separate worksheets within the same workbook.
Any help really appreciated!
Thank you,
Meg

 

[pboltonchina]

Use the ASAP Utilites add in that has this feature under the Import tab.

http://www.asap-utilities.com

 

[bmeghana]

Hi..thanks for the info. Is using that add-on the only way to do this? Since its not a Microsoft based software, i may need to go through validation processes to use any external software. Any other ideas really appreciated. thank you!