Alternate way for "Find and replace"? PlsHelp

Hello,

I have an excel workbook which i have to change it everyday. It has two sheets: one of them the operators inputs the daily values and in the second sheet which I operate there are statistical formulas like standard deviation min value max value mean and average. Every morning I open the first sheet and read the row numbers for the day before values entered I note them go to the statistics sheet and "edit -> replace" ( or ctrl+h) and change the row numbers of the statistical formulas row numbers according to the noted row numbers and get the new daily numbers.

To illustrate
=STDEV('FRDG 2010'!H7270:H7377)
25/12/2010 values start in the sheet FRDG 2010 at row 7270 and ends at 7377
26/12/2010 values start in the sheet FRDG 2010 at row 7374 and ends at 7482

I do this by ctrl+h ==> find what 7270 replace with 7374 ok
find what 7377 replace with 7482 ok
I got the new standard deviations etc.




Can I do this automatically?

I tried such a way but could not manage it; I used vlookup function to read the row numbers with today function to read the date and look it up in the first page. Upto this point I got the values ( row numbers that the values of the day before's values started and ended) but couldnt find a way to put them in formulas.