in the new sheet in cell A1 enter
=Sheet1!A1
assuming your names are in Col A in Sheet1

Copy it down till you cover much more that what is used in Col A in Sheet 1
(to accommodate future additons)

Filter on Non-blanks... this way you will always see team names even if you
add new ones in Sheet 1...

"Allen" wrote:

I've got a file with two worksheets...the first sheet has team names in the
first column in non-consecutive rows (there's other information about each
team on the rows in between) and I want to transfer those team names to
consecutive rows in the second worksheet with a formula (so that when the
teams change, the second sheet does too) but I want the flexibility of adding
additional rows between the team names without effecting the working of the
second sheet. The team names are the only information pieces in the first
column.