I have a macro that copies elements of a Template worksheet to create
new sheets. The new sheets are for the most part identical except that
the data values are different. I need to copy a chart that is on the
template sheet to the other sheets and have it pick up the same
sources, just with the new sheetname. Just copying the chart and
pasting results in a chart referring back to the template sheet.

Any Ideas where I should start?

Thanks
Robert