Workbook Combine

The attached macro will loop through all open workbooks, and combine the sheets from them into a single new workbook.  It has the option to only include the first sheet, or all sheets from the source workbooks.  

Feel free to use or modify this macro as needed.

Thanks to Shelley and The Jankovich Company for generously sponsoring the development of this macro!

AttachmentSize
CombineWorkbooks.xlsm26.91 KB
CombineWorkbooks.xls51 KB

Workbook Combine