chart referencing
 

Hi,

I have 46 worksheets acting as a database, and each worksheet is going to be
exactly the same except for the data enetered.

I have used worksheet 1 to make up everything I need and I am going to
simply copy and paste worksheet 1 as a template for the remaining 45
worksheets.

This works fine until I get to the charts which when copied to another
worksheet remain referenced to worksheet 1.

Is there a way to remove this so as the chart automatically references the
new worksheet?

Many thanks in advance for your help,

kind regards,

Ant