Copying and Pasting Tables and Graphs.

Hi.

I'm developing a tracking sheet for work, which is used to monitor the time of rebuilds undertaken upon a machines. Previously it has only been a table with the planned dates of completion and actual dates of completion. However, recently I have created a number of graphs to visually display this information from the tables so that myself and other workers can relate to the information more easily and it is has been acknowledged as critical information for presentation at regular work meetings.

I have been asked to produce a macro so that others can use this tracking sheet with ease. The macro itself is very basic it just copies and pastes in a blank copy of the tables and graphs which are stored on another sheet, above the last completed tracking table.

This issue I am having is the graph references, they are maintaining their reference to the first table produced, thus I have to manual go through and change the data references for each of the charts each time I start a new tracking table. Is there a way to prevent the graph from doing this and just maintaining a cell reference to the table they were pasted in with not the original blank copy stored on another sheet? Please take note that they must all be pasted into the same sheet, I cannot just produce numerous excel spreadsheets.

Thank you in advance for any help on this issue.