Calulation between sheets

Hi,

I have an inventory spreadsheet that I am trying to figure out how to update the total inventory when I enter orders and re-stock of inventory.

The first sheet is all of the inventory, second is all incoming orders, third is inventory re-orders placed. I would like for the total inventory to be added or deducted when incoming orders or inventory re-orders are placed in their respective sheets of the workbook.

Hope that makes sense. Thank you!

Suggest you post a copy of your workbook with sample data. It will be easier to provide you with a response once we see your layout.