Need some advice on Inventory document

I’m trying to make an inventory document for 3 office locations. Each location should have their own inventory list that quantities can be updated. I could use some advice on the following:

  • List item I would like to make the inventory items pull from one master list of items.

  • List item Generate a report, or a “view of” summarizing the items that need to be ordered for all of the locations in one sheet

Any advice would be greatly appreciated.