If pulling data from other documents is not enough and you'd rather do some math with all those records, Consolidate Sheets is the add-on to go with. It not only merges multiple Google sheets but also calculates numbers at the same time.

The tool will definitely spare you monotonous copy-pasting and building Pivot tables or QUERY formulas. What's more, you won't have to open each spreadsheet anymore. You just tick off the sheets you'd like to process, specify ranges if necessary, and Consolidate Sheets summarizes data from there.

4 merging options let the tool consolidate data of different structures:

  • consolidate by header row
  • consolidate by first column labels
  • summarize data by both headers and column labels
  • consolidate by position

11 consolidation functions built into the add-on provide different summary reports: 
SUM, COUNT, AVERAGE, MAX, MIN, PRODUCT, COUNT NUMBERS, STDEV, STDEVP, VAR, VARP.

As an extra, you will also choose where to place the consolidated data: 
  - new spreadsheet
  - new sheet
  - custom cells within the opened spreadsheet

30 DAYS OF FREE USE

Fully functional 30-day trial period. All payments are secure and include an unconditional 30-day money-back guarantee.

Consolidate Sheets is a proud member of the Ablebits product family. We build add-ons that help you make the most of G Suite. Visit our official website https://www.ablebits.com/google-sheets-addons.php to learn more.

If you have any questions please post them here: https://www.ablebits.com/docs/google-sheets-consolidate-data/ 
We'll be happy to assist!