The tension in Slartibartfast39's scenario is real and familiar: three teams, three workbooks, one shared project. The instinct to pull everything into a single dashboard is sound, but the pushback from protective teams is equally understandable. Our take is that the answer isn't consolidation, it's connection. What this reader needs isn't a single workbook that everyone owns, but a single view that respects each team's autonomy.
That distinction matters. When Chemistry, Physical, and Petrography each guard their own tracking sheets, they aren't being difficult. They're being human. Ownership over data often means ownership over process, and asking people to merge their workflows into one file can feel like asking them to give up control. The better path is to build a lightweight system that reaches into each workbook, pulls only the fields you need, project number, client, project name, due date, and team, and skips anything with a completed date. No one loses their private workbook. Everyone gains a unified view.
This is where modern spreadsheet tools earn their keep. The reader's question, "Is that reasonably do-able?", has a clear answer: yes, and it doesn't require a database migration or a new software purchase. A well-designed query, a simple import function, or even a shared sheet with live references can do the work. The key is to design the connection so that it's invisible to the teams. They update their own files as always. The dashboard updates itself. The friction disappears.
The practical win here isn't just cleaner data. It's the removal of a bottleneck. Right now, someone likely has to manually compile project statuses across three workbooks, chasing down updates and reconciling dates. That person's time is better spent on analysis or coordination. By pulling only what's needed and excluding completed projects, you get a live summary that tells you, at a glance, what's active and who owns it. That's not a technical feat. It's a workflow decision. And it's one any team with three spreadsheets and a shared project list can make today.