Okay, here's my situation:
I have a bunch of workbooks, which all have ~10 worksheets. Data is located in the same cell in each workbook (in other words, Cell B4 will always represent 2007 Revenue, Cell C4 will represent 2008 Revenue, etc. regardless of the workbook.)

I have rather complex graphs which I have created in one workbook, and want to add to all. If I do a regular copy and paste, the data in the graph links to the original workbook. Is there a way to have the data for the graph automatically link to the current workbook?

I can rather easily do a 'Find&ReplaceAll' to update any copy&pasted cells (formulas) to act on the current workbook, instead of the original, but I've noticed the 'Find&Replace' feature does not work on data defined within graphs/charts.

Is there any way to copy a graph in one workbook, and paste it into a new workbook, and have it graph the data located in the same sheet/cells in the new workbook?

Or, even better, is there a way to 'Group' workbooks, so that I have a 'master template' that will automatically change all the other 'slave' workbooks?