A fairly simple way would be to just reference the Sheet1 column containing the names in each of the subsequent sheets.

eg

Imagine Sheet1 has 3 people in cells A1 to A3
Alan
Frank
Mary

In sheet2, cell A1 you would have the formula: =Sheet1!A1
and copy this formula down to say A100 (or A64000 if you're feeling generous)

this will therefore show the list of names in Sheet2 that are in Sheet1.

Thats at its most basic, as you'll see if there isnt anything in the cell of Sheet1 then it puts a zero in the Sheet2 cell so to get around that make your formula =IF(ISTEXT(Sheet1!A1),Sheet1!A1,"") so it only displays something if theres TEXT in the cell.

theres many other solutions but thats probably the easiest one to use.