Merge Multiple Excel Sheets to One Sheet

We have a system that generates a report that we have to give to our consultants in an Excel spreadsheet. When we convert the report to Excel, it puts one page in one tab, so the 300 page report is in 300 tabs.

In Excel 2007, is there a function to merge multiple sheets into one sheet?

Any help to make the consultants happy would be appreciated.

Edited for the usual typos.