AVT100 Consolidate Sheets add-on for Google Sheets Lifetime subscription ID 26076791
Add up columns and rows from several sheets into oneConsolidate Sheets merges numerous sheets from different files and calculates numeric records at the same time. There's no need to open each spreadsheet — a quick search and a simple tree view let you handle all tables in one window. Consolidate Google sheets by rows and columns, or summarize cells based on their position in tables. 11 built-in functions will aid with different summary reports that you can place wherever you prefer.
