I have two tabs in an excel worksheet. Tab A has data, Tab B has graphs from
the data in Tab A. When I copy and paste these two tabs into the same
workbook, I get Tab A (2) and Tab B (2). The problem is that the graphs in
Tab B (2) are still referencing the data in Tab B. I have to go in and
change the source data from Tab B to Tab B (2). Is there a way around this
procedure or do I have to go in and change the source data everytime I copy a
tab with graphs?

Thanks

Chris