AVT100 Combine Sheets add-on for Google Sheets Lifetime subscription ID 4729643
This add-on offers a great opportunity to consolidate data from many spreadsheets into one. Even if your tables differ in formatting, column order, or content, Combine Sheets will perfectly join everything you have in one table using the column headers. You dictate the add-on what sheets to compare, what to do with formatting, and where to put the results on two quick steps.Combine as many spreadsheets as you needAdd sheets from Google Drive using quick search fieldUse entire sheet or adjust the range manuallyTransfer the formatting of the original datasetsReview the result in a new spreadsheet, sheet, or a range of your choiceWhat's more, you can separate combined sheets with empty rows. This way you'll be able to scan through the consolidated data easily and work with it faster. Try it yourself and you won't regret it.