help with writing IF formula

I kept your existing format. But you will see it complicates the formula.

You need a different formula for each staff member.

Formula:

=IF(ISERROR(SMALL(TRANSPOSE(IF(Sheet1!$F$4:$F$3000="H",Sheet1!$A$4:$A$3000,"")),COLUMN()-1)),"",SMALL(TRANSPOSE(IF(Sheet1!$F$4:$F$3000="H",Sheet1!$A$4:$A$3000,"")),COLUMN()-1))