|You do know that you can select all of the sheets in a workbook and copy them to another workbook all at the same time, right?|
With the first tab selected, press the Shift key and click the last tab to select all of the sheets.
Right-Click and Copy all the sheets to the destination workbook.
Your other option is to use a macro such as the one found here:
If you Google macro to combine workbooks or something similar, you'll find lots of VBA options to consolidate workbooks.
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.