Using Excel 2002

I created a pie chart on one sheet tab (Sheet1). I have 10 tabs of raw data.
The data resides on their respective tabs. I want to use the same chart and
format for each tab. I copied the chart from Sheet1 and pasted it to Sheet2.
Then I right-clicked on the Sheet2 chart and changed the source data to
refelct the data on sheet2. Is this a glitch or somethin? It doesn't update
my data labels correctly. The percentages are wrong and it keeps the same
category names from the Sheet1 chart. How can this be fixed so I don't have
to recreate the chart each time?

Thank you, Karen