This user's problem is not unusual, and it is not their fault. The real issue is that traditional spreadsheets were never designed to handle this kind of relational data flow. What they are describing, a master customer list that needs to pull live data from individual Profit and Loss files, is a perfectly reasonable request. Yet the tools they are using force them to choose between manual double-entry and a maze of fragile formulas that break the moment a file is moved or renamed. That is not a skill gap; it is a product gap.
The practical consequence is that users like this one spend more time managing the spreadsheet than managing the business. Every new customer means a new folder, a new P&L file, and a new opportunity for a broken link or a forgotten update. The work becomes brittle. One misplaced cell reference and the main sheet is showing stale numbers. The user knows what they want: automation that respects the structure of their data. They want the master sheet to behave like a live dashboard, not a static archive that requires constant manual maintenance. That is not asking too much. It is asking for the right thing.
This is where an AI-native approach changes the equation. Instead of forcing the user to build manual bridges between files, the system can understand the relationship between the customer record and the P&L sheet. It can recognize that the customer name in the master list corresponds to the customer name in the folder, and it can pull the relevant profit-and-loss figures without the user writing a single formula. The data stays in its natural home, each customer's P&L remains their own file, but the master view updates automatically. The user stops being a data janitor and starts being an analyst.
The takeaway is straightforward: if your workflow feels like it is fighting the tool, the tool is the problem. This user's request is not a niche edge case. It is the core challenge of modern data management, connecting disparate sources without sacrificing accuracy or speed. The solution is not to teach people to be better spreadsheet mechanics. It is to give them a system that understands the relationships they are trying to express. That is the shift worth making.