This user is not asking for a feature request. They are describing a daily reality: a multi-sheet inventory workbook where sorting one zone means manually re-sorting every linked page, hoping nothing breaks. The question they posed, can Excel be coded so all pages sort together, is a reasonable one. But the deeper truth is that they are wrestling with a tool that was never built for the way they actually work.
Traditional spreadsheets treat data as static blocks on individual sheets. When you sort a column, you are rearranging cells in one location, and any dependent sheet must either be recalculated or manually re-sorted to stay coherent. The user's four linked pages are likely using formulas that reference specific cell addresses; a sort changes those addresses, and the links break or produce mismatches. This is not a user error. It is a design limitation of the tool itself. The workaround, writing macros, locking references, or manually re-sorting each sheet, adds complexity without solving the underlying problem: the data is not truly connected.
What this user needs is a system where the data lives in one place and the sorting logic applies universally. An AI-native spreadsheet does exactly that. Instead of managing cell addresses across five sheets, you define a single dataset and let the tool handle the relationships. When you sort by zone from smallest to largest, every view, every page, every summary, updates automatically. The human effort shifts from maintaining links to interpreting results. That is the practical transformation here: less time spent fixing broken references, more time spent understanding inventory patterns.
The frustration is not about sorting. It is about a tool that forces users to become amateur programmers just to keep their data aligned. The solution is not a better macro or a clever formula. It is a spreadsheet that treats data as a living, connected system rather than a collection of isolated cells. For anyone managing multi-sheet workbooks, the path forward is to stop wrestling with the limitations of legacy design and start using a tool that works the way your brain does, where sorting one view sorts them all, automatically.