Excel Formula Query

Hello everyone, this is my first post, so I hope you can help me. I am trying to create an excel inventory spreadsheet which logs the sales of products and then automatically updates the ingredient inventory list that made up that product. For example if I sold 1 ham sandwich which used 2 slices of bread, 2 slices of ham, 10grams of butter, 1 plastic container and 1 label – then by entering “1” into the “ham sandwiches sold” column, would some how link to and update the ingredients sheet behind it. This would mean ingredients stock levels would be managed by the products sold column, rather than manually updating each ingredient/component column. Any ideas?