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.