If all of the cells in column A on Sheet1 are filled, this would do it for
you. In any cell on Sheet2:
=OFFSET(Sheet1!A1,COUNTA(Sheet1!A:A)-1,0)

"widman" wrote:

Is there a formula I can put on a worksheet that picks up the values from the
last row entered in the previous sheet, changing as rows are added.

In other words, this forumla in A1 of sheet 2 would show the value of A20 in
sheet 1 until values were put into A21, then they would show the values from
A21, then A22, etc.