Combining Excel Files

Copper Contributor
I have 140+ Excel files (one tab each with data) that I would like to combine into one worksheet with 140+ tabs. What's the fastest and easiest way to do this?
3 Replies

@MirsadaMK 

Here excel - Copying worksheets from multiple workbooks into current workbook - Stack Overflow are some scripts for that. Not sure, if you are not familiar with VBA, entire cycle will be faster than manual copying of sheets (I guess it could take about an hour), nonetheless. 

Thank you, but I'm not familiar with VBA at all, and was really hoping there is something else I can use beside copying manually.

@MirsadaMK 

To my knowledge no such. Programming or from right click menu on tab name.