I have a workbook that contains my data and use another workbook to create various reports based on that data. The reports require fairly tedious formulas and so I want to avoid having to re-write the reports each week as new data is added.

My solution was to make the data spreadsheets contain six months of data and delete the last week and add a new week at that start of each week.

If my report workbook DOES NOT update and just looks at the cell references it will work. How can I make sure the report workbook only sees the cell references and does not "know" that I moved the data around.

Also, of course, any help on how to keep reports like these current another way would be greatly appreciated!

M