How to sort only one type of data from a column

Hi,
I am working on a large database, and for that database we need to sort some of the information out and transfer to another sheet. I want to look at only specific data to perform some analysis. For instance, in a spreadsheet that has both male and female workers, how do I create a separate list of only female workers in a new sheet for the same workbook? The only thing that I could think of is VLOOKUP but I am not sure if that will work. Any help would be appreciated! Thanks in advance for your time!

Please post a sample file (not image) demonstrating what you require.

To upload a file, click "Go Advanced" then scroll down to "Manage attachments"

Hi @Ranh
You want create a new table filtered or filtered and sorted? Why not use filter, sort, copy, paste?
Assuming you want dynamically filter to a new table in a new sheet, and assuming your first table is Table_A with (Name, Gender, Age) in Sheet1
You can use the following formula in Sheet2 Table_B with(Row_Id, Name, Gender, Age) to get the rows you want transfer ($G$2 has the Filter for Gender).

Formula:

=IFERROR(AGGREGATE(15,6,1/((Table_A[Gender]=$G$2)/(ROW(Table_A[Name])-ROW(Table_B[#Headers]))),ROWS($A$1:$A1)),"")

Now, you can use INDEX to fill the rest of Table_B as (to get column Name

Formula:

=IFERROR(INDEX(Table_A,[@[ID_Row]],COLUMN([Name])-1),"")

See the sample file