There's a better way to do this, and it doesn't involve copying a query a dozen times. The Reddit user who built one query per bank account, then duplicated it for each new tab, ran straight into the performance wall that traditional spreadsheets leave you to climb alone. They felt the slowdown. They suspected inefficiency. They were right.
The core problem here isn't the user's approach, it's that Excel treats each query as an isolated operation. When you copy a query and change only the account name, you force the tool to reload and reprocess the same folder structure, the same file formats, and the same transformation steps from scratch for every single tab. That repetition multiplies the workload. Refresh times compound. What should be a streamlined workflow becomes a waiting game.
A smarter solution collapses those separate queries into one. Instead of asking Excel to run a distinct process for each account, you can design a single query that pulls all statements, then groups or filters the results by account directly inside the data model. This isn't some exotic technique, it's a fundamental shift from doing repetitive manual work to letting the tool handle the logic. The folder stays the same. The file format stays the same. The only variable is the account identifier, which you already have in each statement. Let the query read that field, then organize the output into tabs or tables based on the value it finds. One refresh. One source of truth. No multiplying queries.
For anyone managing monthly bank statement uploads, this change turns a sluggish chore into a reliable process. The time you save isn't just the minutes spent waiting for refreshes, it's the hours you no longer waste maintaining a dozen near-identical queries. The next time a new account appears or a statement format shifts slightly, you update one query, not twelve. That's the practical payoff: less complexity, faster results, and a workflow that scales without breaking.