How do I make a master cost sheet talk to all of my existing cost sheets?

I have been given the daunting task to update the new costings every year, for every item in our inventory. we make playgrounds so each item we sell is made up of several sub items.

we have thousands of existing cost spread sheets. one for each play system that we have sold in the past.

so in order to update the costing I have to go into each spreadsheet and update the prices for every single sub item (all the parts that make up a whole playground) for each of our existing playgrounds.


There has got to be a better way....


Is there a way to make my master cost sheet talk to the rest of the (1000) other spread sheets so that I can update the new prices of all the sub items in one master sheet that communicates to the rest of my existing spread sheets?

We have a master list but as of now it does not reference anything. How can I make other sheets reference the master.

what I have is a little different.

I have a master part list with prices and quantity set to 0.
then for each playground I have a copy of the master with the quantity of each part set-up.

I need a way to change the prices on the master so that it also changes them on all of the existing price sheets.