Interlinked Multi-Sheet Excel Stock Tracker

I need a single workbook in Excel 2013 that will let me track 50-100 different stock items across six locations and one master sheet. Each sheet must share the same first column (Item Description), followed by Opening Stock, Stock In, Calculated Total (Opening + In), Stock Out, and Closing Stock (Total – Out). Whenever I add or remove an item on any sheet it must instantly appear, in the same order, on every other sheet.

Here’s the twist: any quantity I record as “Stock Out” on one of the six secondary sheets should automatically roll up as “Stock In” on the master sheet for that same item. At the end of each day the Closing Stock on every sheet becomes the next day’s Opening Stock; I will type the daily movements manually, so an easy “new day” button or a simple macro that copies yesterday’s closing values into today’s opening column will keep things tidy.

Because I’m on Excel 2013, please rely only on functions and VBA features available in that version. Everything has to stay inside a single, clearly structured .xlsm file so I can distribute and update it easily. A short set of usage notes explaining how to add new items, start a new day, and clear any mistakes will round out the job nicely.

Deliverables:
• One fully linked Excel workbook (.xlsm) with a Master sheet + 6 identical location sheets, complete with all formulas/macros described above
• Brief, step-by-step instructions for day-to-day use and maintenance