Automatically adding additional information to a chart on a weekly basis

On a weekly basis, I need to report on our metrics. I have already set up an excel spreadsheet where I enter the information on a separate tab, and the information automatically updates with a rolling 10 week summary of our metrics, including a chart.

Now, I am being told that instead of using a rolling 10 weeks, they want the information to just keep adding week after week, so every week there will be one additional set of data to graph.

Is there a way to do this automatically, once I enter my information into my data tab?

I am currently using names to identify the last 10 rows in each column, and that is what is is using to chart.

I am not in the office, so I am not able to attach an example, but if it is necessary, I will do so on Monday. I am using Excel 2003