Consolidate Multiple Google Sheets

I keep data in more than ten separate Google Sheets that all share the exact same column headers. I now need one master sheet that automatically pulls every row from each source and appends them into a single, ever-growing table.

The goal is straightforward: append all rows from each sheet, no summarizing or separate tabs. Because the structures match, there is no need for column mapping; it is a straight union of data.

I am happy for you to use Google Apps Script, IMPORTRANGE with ARRAYFORMULA, or any other native Google Workspace method that avoids paid add-ons. Live syncing would be ideal, but a simple on-demand trigger is acceptable if it keeps things stable and easy to maintain.

Deliverables
• A working master sheet that shows the full combined dataset.
• The script or formulas running the merge, placed inside the file with clear inline comments.
• A brief set of instructions—or a quick Loom-style video—showing how I can add more source sheets later.

Acceptance criteria
• All existing rows from the 10+ source sheets appear in the master without duplicates.
• New entries in any source sheet flow into the master automatically (or via the agreed trigger) within minutes.
• Column order and headers remain identical to the originals.

Please share your estimated turnaround time and let me know if you need access or sample files to get started.