Excel

I have an excel spreadsheet that has our site inventory in separate worksheet tabs (with each site’s name) and one worksheet that has all of the inventory in it from the individual site tabs. My question is, is there a formula that I can use whenever I make a change in the master worksheet, so it will make the change in the approiapite site worksheet? or would it be too much of a headache to use the formula (if there is one)