Use Spreadsheet Consolidator add-in to create, to consolidate many sheets easy and quickly. This toolbar has the following useful tools:

   Consolidator (Creating models)
    Work with consolidations models
Multi-Sheet Consolidator
Smart Consolidation
Detailed Consolidation
Consolidate ranges
Conditional text
Merge tables
Export sheets as ...
Freeze | Divide panes
Toggle settings
Arrange windows
My favorites
Sheets manager
Workbooks manager
Arithmetical calculator