How to Combine Multiple Tabs Into One Master Sheet

You have the same table split across a tab per month, per store, or per person, and you want them stacked into one. Here's how to do it with a formula that stays live — plus the honest limits when the tabs don't line up.

By the Quiriz Team · Published August 4, 2026 · 5 min read

The quick version: to stack the same table from several tabs into one, list their ranges in a curly-brace array separated by semicolons — ={Jan!A2:D; Feb!A2:D; Mar!A2:D}. It builds one live master that updates when the tabs do. Here's that, plus filtering while you combine and the case where the tabs don't line up.

Stack the tabs with a curly-brace array

If every tab holds the same columns — say date, item, region, amount in A:D — put your headers in row 1 of a new Master tab, then in A2 type:

={Jan!A2:D; Feb!A2:D; Mar!A2:D}

The semicolons stack the ranges vertically. Starting each range at row 2 skips the repeated header on each tab. Every range must have the same number of columns, or you'll get a mismatch error. Change a source tab and the master updates on its own — no copy-paste.

Filter and clean while combining

A raw stack drags in blank rows from ranges like A2:D. Wrap it in QUERY to tidy as you combine:

=QUERY({Jan!A2:D; Feb!A2:D; Mar!A2:D}, "SELECT * WHERE Col1 IS NOT NULL", 0)

Because the input is an array, refer to columns as Col1, Col2 — not A, B. You can go further and summarize in the same formula, e.g. total amount per region across all three tabs:

=QUERY({Jan!A2:D; Feb!A2:D; Mar!A2:D}, "SELECT Col3, SUM(Col4) WHERE Col1 IS NOT NULL GROUP BY Col3", 0)

Combining tabs from another spreadsheet

If some tabs live in a different file, pull them in with IMPORTRANGE and stack the results the same way:

={IMPORTRANGE("URL","Jan!A2:D"); IMPORTRANGE("URL","Feb!A2:D")}

Click Allow access on the first #REF! to connect the files.

When the tabs don't line up

The curly-brace approach assumes every tab has the same columns in the same order. Real spreadsheets rarely stay that tidy — one tab gains a column, another renames a header, a third puts region before date. Once that happens the formula gets brittle and you spend more time patching the master than using it.

At that point it's worth asking what you actually wanted. Usually it isn't the master sheet itself — it's an answer that spans the tabs. If that's the case, combining is a means, not the goal.

💬 Skip the formula: if the reason you're stacking tabs is to answer one question across them, the Quiriz add-in reads them directly — ask =QUIRIZ("total amount by region across every tab", "table") and skip building the master sheet at all. It also doesn't care if the tabs have slightly different columns.

You wanted the answer, not the master sheet

Quiriz reads across all your tabs and answers questions in plain English with =QUIRIZ() — no stacking, no matching columns. Free to start.

Try Quiriz free →

Frequently asked questions

How do I combine multiple tabs into one sheet in Google Sheets?

Put each tab's data range in a curly-brace array separated by semicolons: ={Sheet1!A2:D; Sheet2!A2:D; Sheet3!A2:D}. This stacks them vertically into one live table that updates when the source tabs change. Add your headers once in the row above.

How do I stack tabs that have the same columns?

Use a vertical array with semicolons between ranges: ={Jan!A2:D; Feb!A2:D; Mar!A2:D}. Every range must have the same number of columns (here, four). Start each range at row 2 so you don't repeat the header row from each tab.

How do I remove the blank rows when combining tabs?

Wrap the array in QUERY and filter out empties: =QUERY({Jan!A2:D; Feb!A2:D}, "SELECT * WHERE Col1 IS NOT NULL"). Use Col1, Col2 (not letters) because the input is an array, not a range.

What if my tabs have different columns?

A curly-brace stack needs the same column count and order in every tab. If the tabs differ, line the columns up first (or select matching columns per tab, e.g. reordering with per-tab QUERY), then stack. When the tabs are genuinely inconsistent, combining by formula gets fragile — that's usually the point to ask the question across the tabs directly instead of building the master sheet.