=INDIRECT("Sheet1!A" & ROWS($A$1:A1)) and copy down
--
Gary''s Student - gsnu200765


"Alissa" wrote:

In an Excel document, I have a list of names that I add to and delete from
daily. How do I create in that same document, but on another tab, a copy of
that list that automatically updates whenever I make a change in the original
list?