Merge Many Workboos into One Workbook

[ThruTraffic]

Sorry if this is answered in another thread. Can't find a keyword set that doesn't produce other types of merges.

I have many workbooks that contain one sheet only. I want to create one workbook and all those other workbooks become worksheets in the new workbook. Have too many to copy/paste.

Can some help me accomplish this?

 

[Trevor G]

Welcome to the Forum,

Look at this link it gives you all the information you will need, copy each part into a single module sheet, then save the workbook in the same location and once done run the code called CombineFiles

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

Just test on a new workbook....

 

[ThruTraffic]

Thank you!!