Create the same charts from a different sheet

[Metric6]

Hello, I am new here and certainly not an Excel expert!

I have an Excel file with two sheets - Sheet1 is a table of various data, and Sheet2 is a set of charts and graphs based on that data. I'd like to add two new sheets - one with a table of the same information but for a different project, and another that generates the same set of summarizing charts and graphs but relating to this second project. Is there a way to achieve this without manually changing all the chart data? Essentially link these two sheets together and duplicate a new set of two sheets that are also linked together?

I hope that is clear and thanks in advance for any help/advice.

 

[awoohaw]

try this: Copy the new data into the 3rd sheet. then copy the charts from chart sheet to sheet 4.
Then edit the charts on sheet 4 to change data source.