Display figures from dynamic range

[uncleslinky]

I have a set of data populated in columns A:DY. (one column for each day going back a few months). I would like to pick out every 10 days and have these figures display at the end of the columns - please see attached workbook for better understanding. test book.xls

The problem I am facing is that each day I add a new column and therefore the formuals would need to move along one cell each day. While I could do this manually, is there a better way to do this?

Thanks

[Cutter]

It's not clear what you mean by Day 1 in your sample. I would have assumed it would be the column B date but that wouldn't cause the problem you are having with your "need to move along one cell each day". So I'll assume Day 1 actually means most recent entry (column DY in sample).
To always get that last column value you could use this in cell EA10:
=INDEX($B10:$DZ10,COUNT($B10:$DZ10))
For Day 10 you could use this in cell EB10:
=INDEX($B10:$DZ10,COUNT($B10:$DZ10)-9)
Use the same formula for the other Day "n" columns, adjusting that last number accordingly. Then select the range with the formulas and drag down.

As you insert new columns the ranges in the formulas will adjust, as will the counts.