I have linked worksheets where there is a row of values on one sheet where a
person's weight is entered (eg., each column is a week and there is a weight
entered for each week for 12 weeks).

We want the other worksheet to just show the latest entry, so that it can be
printed and sent out.

How can I make this Workbook "smart" enough to know?