I have a worksheet that keeps undating everyday. I want to track the
latest row's value and still keep the old one.

Example

A1 will always point to newly updated cell (B1, B2, B3 ... )

Day1, update on B1 <--A1 shows value of B1
Day2, update on B2 <--A1 shows value of B2
Day3, update on B3 <--A1 shows value of B3