I need to find all female and all male that is on 1 sheet and created the
result onto the other sheet.....

I need to take all info beside each F and created a list and Each M beside
the name a created a list into another sheet, all the information beside need
to be taken as well....

Basically,



Ex:
M Yan 252 3000
M BOB 246 25500

F Kim 256 30124
F Pat 300 25466