There's a better way to duplicate Power Queries across worksheets without touching the code, and it doesn't require a source table. The core problem here is familiar to anyone who manages multiple identical queries that only differ by source worksheet. Manually editing the M code after each duplication is tedious, error-prone, and counterproductive. You already know the queries are the same; the tool should honor that.
The workaround you're trying to avoid, a table listing all the sources, is one common solution, but it's not the only one. A parameterized query lets you define the source worksheet as a variable, then duplicate the query and change only that single parameter. This approach keeps your M code identical across duplicates. No copy-paste errors, no missed references. Excel's Power Query editor supports parameters natively, and they can be driven by a simple named range or even a cell value if you prefer not to maintain a full source table. The result is a clean, maintainable set of queries that scale with your worksheets.
This matters because your time is better spent analyzing data than fixing broken references. Every manual edit introduces risk, a typo in a sheet name, a forgotten update when a new worksheet appears. A parameterized setup removes that risk entirely. It also makes your workflow more transparent: anyone inheriting your file can see the pattern immediately, rather than reverse-engineering a chain of modified queries. The learning curve is minimal, and the payoff compounds with each new worksheet you add.
So here's the practical takeaway: stop editing code by hand. Create one master query with a parameter for the source worksheet name, then duplicate it by copying the query and changing only that one parameter. No table required, no fragile M code surgery. Your future self, and your colleagues, will thank you.