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

Consolidation

Consolidator (Creating models)

Work with consolidations models

Multi-Sheet Consolidator

Smart Consolidation

Detailed Consolidation

Consolidate ranges

Conditional text

Merge tables

Tools

Export sheets as ...

Freeze | Divide panes

Toggle settings

Arrange windows

My favorites

Sheets manager

Workbooks manager

Arithmetical calculator