Excel Inventory Tool Formula Fixes

I have an existing Excel-based inventory workbook that has started to behave unpredictably. Data entered in one sheet no longer flows through to the summary pages, several formulas now return #REF! or #VALUE! errors, and the overall stock-on-hand figures are plainly wrong.

What I’m looking for is a deep clean of the workbook, with particular attention on the inventory tracking formulas. Please trace the current logic, identify the break points, and rebuild the calculations so that every time new stock is received or sales are logged the counts update instantly and accurately.

You will have access to the current .xlsx file plus a short note describing the intended flow. I just need one deliverable: the repaired file, ready for everyday use, with all inventory totals populating correctly after your changes.