How to retain previous data pulled from a dynamic worksheet

I have attached a sample of what I am trying to do and I appreciate any help!

I have a workbook with two sheets (Data and Current). The Worksheet called Current is dynamic and on a weekly basis the data is overwritten.

On the worksheet called Data I have static groupings set up broken up by week.

To better illustrate, within the 2/11/2008 group I used the simple formula of =Current!B2 and ideally I would use this formula with the 2/18/2008 grouping and so on(since these cells never change). However, as i'm sure you know as my Current worksheet updates so do my weekly stats from previous weeks.

I don't want the data from previous weeks to change as the Current worksheet gets updated.

Is this possible?

Thank you for the help!

one way would be just to use the same formulas all the time so as week one is entered it also updates all the other future weeks.
at end of week 1
copy data all of week ones layout a1 through g30 then just paste it back as paste special values. this will remove the formulas and leave the values
then clear the values from current and start over with week 2

Thank you for the reply. I'm sure I didn't explain myself well enough.

What you described is essentially what I am doing (opening the workbook each week and copy/pasting-special-values). I am looking for a way to automate the process.

So if I were to open up my workbook next Monday I would last weeks data (unchanged) in the 2/11/2008 grouping and the 2/18/2008 grouping with the Current data.

I am not sure if a formula can work or if VBA is an alternative.

Thanks again.

Absolutely brilliant! That works even more perfectly than I had imagined!

Thank you so much for the help!