There's a moment in every spreadsheet user's life when the tool that was supposed to organize work becomes the work itself. The person behind this post has 170 staff sheets, each holding a single name in a single cell, and they need those names in one clean list. That's not a niche problem. That's the daily reality for anyone managing part-time teams, contractors, or volunteers. The request is simple, but the scale is overwhelming. And the response from the community matters more than the trick itself.
What stands out here is not the technical difficulty. Any intermediate user could solve this with a few formulas or a script. The real challenge is the mental weight of starting. When you have 170 tabs, you don't see a spreadsheet anymore. You see a wall of manual work. You imagine copying and pasting for hours, making mistakes, missing a name, and then reconciling the whole thing again next month. The question posted is not really about cell references or ranges. It's about whether there's a better way to spend your time. The answer is yes, but only if you know where to look.
For the person asking, and for anyone who has ever felt stuck in a similar loop, the practical path forward is not a single heroic formula. It's a shift in approach. Instead of treating each sheet as a separate universe, you treat them as one dataset with inconsistent packaging. You use a dynamic reference that pulls from each tab by name, or you use a tool that consolidates without needing to touch every cell. The names are already there. The structure is already there. What's missing is the permission to stop doing things the slow way just because that's how they've always been done.
The takeaway here is not about 170 sheets. It's about the principle that applies to any repetitive task: if you're doing it manually, you're doing it twice. The first time is the actual work. The second time is the habit. The person who posted this is already ahead of the curve because they asked. They admitted the manual approach was unsustainable. That's the first step. The next step is to build a solution that works once, and then reuse it. Whether that means learning a simple query, using a script, or switching to a smarter tool, the goal is the same. Get the list, get it fast, and get back to the work that actually needs a human. That's the point. Not the formula. Not the macro. The time you get back.