If or VLOOKUP in excel sheet

Image 1

See Here in Image 1, I want to sort all the male and Female in a different Sheet Like if Column D read Male Than it Should automatically Show in another Sheet, Something like given in Image 2,

Image 2

What Formulla or tool I should use...

Thanks in advance...