I have row AI3:CH3 with data added each week. For example after 4 weeks,
AI3:AL3 has data and the rest of the row is blank. Each week, I add a value
in the next cell to the right of the previous week, so by the end of the
year, I will have 52 values filling AI3:CH3.

What formula will look at this row, and display the "right hand most value"
ignoring all the blank cells in the row. IE I need to have displayed the
value each week, for the week prior (in another worksheet)

Thanks