show a list of names on from sheet 1 in sheet 2 when marked active in sheet 1...???

If sheet 1 data starts in row 1 insert a new line above this (you can put headers for each column if you want).
In C2 type =IF(B2=1,MAX($C$1:C1)+1,"") and drag down as far as required. This will give each row you enter a 1 in a number 1,2,3,4 etc.

Now on sheet 2 in A1 type 1. In B1 type =IFERROR(INDEX(Sheet1!B:B,MATCH(A1,Sheet1!C:C,1)),"")
In A2 type =A1+1 and then drag B1 down to B2. Select A2 and B2 then drag both down to populate the sheet with active values from sheet1. Note when Col B starts showing blank values you have got all your active values listed.

Try this...

With your data in the range Sheet1 A2:B10...

This array formula** entered on Sheet2 cell A2:

=IFERROR(INDEX(Sheet1!A:A,SMALL(IF(Sheet1!B$2:B$10=1,ROW(Sheet1!B$2:B$10)),ROWS(A$2:A2))),"")

** array formulas need to be entered using the key
combination of CTRL,SHIFT,ENTER (not just ENTER).
Hold down both the CTRL key and the SHIFT key
then hit ENTER.

Copy down until you get blanks.