I display (link) one cell on a worksheet page "Houses Sold" from a table
containing a range of cells on another page.

I manually enter the column of numbers, and then go to the next page in the
workbook and change the cell with "Todays" amount.

How do I make the next page reflect the most current entry in my dated row
of data?

Example:

DATE # of houses sold
1 jan = 1
2 jan = 2
3 jan = 3
4 jan = 4
5 Jan = 5

No one wants to see the raw entry data, they only want to see how many
houses I sold today on a seperate page. How do I make that cell on that page
reflect the most current entry from the column of data ....(from today)?

Thanks, please help. Mary