I have a series of spreadsheets that utilize a number at the top which then
use formulas to create prices. There are many sheets that use the same number
at the top. What I want to do is have these numbers in on master sheet and
then replicate the cells in each of the other sheets.

The trick is the sheets are all separate file names and not worksheets
within one workbook.

Thank you in advance.