I have set up a chart that automatically updates as new data is entered into
the spreadsheet. The problem is....I would like to copy this worksheet so
that there are 9 different worksheets (of this same set-up only with
different names) in the same workbook. What is the correct way for me to
make copies of worksheet, so that my chart in each worksheet still
automatically updates based off of what is entered in that worksheet?

The directions I used for setting up my original worksheet is located at
http://peltiertech.com/Excel/Charts/DynamicCharts.html Maybe this only
works for one worksheet per workbook??

I have tried making a copy of the original and changing the name but then
this also changes the original.

Help is appreciated....thanks.