There's a quiet frustration in the post from u/candyqueen1990 that anyone who has ever managed a kitchen or a food business will recognize immediately. The memory of a better workflow, half-remembered and just out of reach, is somehow more annoying than never having known it at all. And the instinct to solve it with a spreadsheet rather than another app is not old-fashioned. It is practical. It is the difference between a tool that works the way you think and a tool that demands you learn its way of thinking.
The good news is that the memory is not a lie. Linked sheets have been a core part of spreadsheet software for decades, and the specific technique described here is both real and straightforward. You keep a master sheet where every ingredient has a current cost per unit. Then, on a separate recipe sheet, you reference those cells directly. When the price of flour or butter changes, you update the master sheet once, and every recipe that uses that ingredient recalculates automatically. No apps, no plugins, no subscription. Just cell references and a little trust in the math.
What makes this approach powerful is not the cleverness of the formula. It is the discipline it enforces. When you build a costing sheet this way, you are forced to separate the ingredient master data from the recipes themselves. That separation is what turns a static list of numbers into a living document. You are no longer hunting through a dozen sheets to find where a price change needs to ripple through. You are not copying and pasting values that will silently go stale. The spreadsheet becomes a system, not a snapshot. For someone who has been running a kitchen on intuition and sticky notes, that shift changes everything.
The deeper point here is that the tools we already have are often more capable than we give them credit for. The urge to reach for a new app is understandable, but it usually means exporting your data into someone else's ecosystem, learning their interface, and hoping they keep the lights on long enough to matter. A linked spreadsheet keeps the control where it belongs: in your hands, in your files, and in a format you already understand. So before you give up on the idea, open a new sheet and test the link. Type an equals sign, click over to the ingredient sheet, and let the formula do the work. That small step is the whole trick, and it is very much real.