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.