Combine Multiple Google Sheets into One – Free Apps Script

Several sheets, one combined view — without copy and paste. A custom menu appears in your spreadsheet's own menu bar, and one click pulls every source sheet into a single destination.

A menu in your spreadsheet, not a web app

There is nothing to deploy here. The script adds an Import Data menu beside File and Edit, with a Start Import item under it. Whoever uses the sheet clicks it the same way they click anything else in Google Sheets — no link to remember, no separate app to open. Both the menu name and the item name are yours to rename.

As many sheets as you have

The source sheets are listed in an array. Add another name to it and that sheet's rows come across on the next run. There is no limit — three sheets or thirty behave the same. Each one's real data range is detected, so a sheet with three rows contributes three rows and one that runs to column S contributes all of it, without you specifying ranges.

Clean every time

The destination is cleared before each import rather than appended to, so running it twice does not double your data. That is the behaviour you want for a consolidated view that is rebuilt on demand, and worth knowing before you point it at a sheet holding anything else.

Written to be understood

This is part of the Apps Script learning series, so the walkthrough explains each function as it goes — adding the menu, hooking it to the open event, reading the data range, clearing content and appending rows. Take the code and run it, or follow it and learn how custom menus actually work.