I am trying to create an inventory summary sheet that will update upon changes to a separate sales sheet and a separate orders received sheet. The list is very basic - just a product number and the number of items on hand. If anyone could help me, that would be awesome. I haven't used Excel in a while, so I'm a little overwhelmed. Thanks.