Is this feasible?

[Deltaecho]

In Sheet 1 I have a class lists with students details( names,
nationalities, etc), I need to extract the students names only from this
sheet and list alphabetically on sheet 2.
To further complicate things, if I remove or add a student from sheet 1
this would automatically be updated in sheet 2.

Any suggestions on how I go about this would be gratefully appreciated.
Thanks

 

[Max]

Perhaps one play to try ..

In Sheet1
------------
Assume the names are listed in A2 down
(In A1 is the col header: "Names")

Using empty cols to the right of the data

Put in say, H2: =CHAR(ROW(A65))
Copy down to H27
(this quickly creates an alpha lookup table)

Put in G2:
=IF(A2="","",MATCH(LEFT(A2,1),$H$2:$H$27,0)+ROW()/10^10)

Copy G2 down as many rows as names are expected in col A,
say down to G200?

In Sheet2
------------
With the same header In A1: Names

Put in A2:

=IF(ISERROR(MATCH(SMALL(Sheet1!G:G,ROW(A1)),Sheet1!G:G,0)),"",OFFSET(Sheet1!
$A$1,MATCH(SMALL(Sheet1!G:G,ROW(A1)),Sheet1!G:G,0)-1,))

Copy A2 down to A200
(same range as the max expected in Sheet1)

Col A will return the names from col A in Sheet1 in alpha order

And any additions / deletions to names in col A in Sheet1
(within the range A2:A200) will be auto-reflected in col A in Sheet2
without any blank rows in-between