Excel 2007 Question

Hello,

I know it is possible to copy an Excel 07 sheet (#1) into another Excel 07 worksheet (#2) and keep the data in tact.

What I want to know is once you copy from #1 to #2, is there an easy way to change the SOURCE worksheet (#1) other than going to each data series and changing it there?

I have a page of data that I am using to create graphs. Since some of the data is similar due to similar areas (but I must keep each particular area separate), I would like to create the data in one file and then just copy the chart into another worksheet. (Normally I create an original worksheet and then just file/save as....however, this time I had already created 4 other worksheets that need this data easily included in them).

Thank you for your help,
Cheryl