I have multiple pricing workbooks pointing to a cell in a master workbook.

When I change the cell in the master workbook, I would like to update all of the pricing workbook without having to open each one individually (There are around 100).

Would I have to use a macro to open each pricing workbook individually after updating the master sheet?

Ian