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?