Copy of a Worksheet Does Not Update Chart References
 

So I have this worksheet called D09. When I do a Move or Copy of the
worksheet and select the Copy box, it creates the new worksheet. I then
proceed to rename it to D08.

BUT, when I import the data into the new worksheet my chart does not work.
When I look at the source data, the thing still references D09. So for
example:

='D09'!LeftLIVP

When it needs to be:

='D08'!LeftLIVP

I even tried creating a template of this worksheet and inserting it that
way, but it fails to update the chart reference every time.

Is there any way to fix this? Excel 2007.

-HoboDan