Building a waiting list

Instead of coming up with a 2nd table, have you considered just applying filters to the list on sheet 1?

Orig table with filters activated
Excel 2016 (Windows) 64 bit

	A	B	C	D	E
1	Last Name	First Name	Status	Gender	Application Date
2	Abraham	Alan	Accepted	Female	1-Jan-24
3	Brinkey	Bob	Pending	Male	5-Jan-24
4	Chiara	Ciera	Accepted	Female	6-Jan-24
5	Delano	Danny	Accepted	Male	10-Jan-24
6	Erikson	Ella	Pending	Female	15-Jan-24
7	Faucet	Frank	Accepted	Male	17-Jan-24
8	Ferry	Farrah	Denied	Female	17-Jan-24
9	Garret	Gerald	Accepted	Male	17-Jan-24
10	Humphrey	Herald	Accepted	Male	17-Jan-24
11	Iskwe	Ibrahim	Accepted	Male	18-Jan-24
12	Joyce	Jessica	Pending	Female	20-Jan-24

Sheet: Data

Filtered table based on Status (1) and then Gender (2)

Excel 2016 (Windows) 64 bit

	A	B	C	D	E
1	Last Name	First Name	Status	Gender	Application Date
5	Delano	Danny	Accepted	Male	10-Jan-24
7	Faucet	Frank	Accepted	Male	17-Jan-24
9	Garret	Gerald	Accepted	Male	17-Jan-24
10	Humphrey	Herald	Accepted	Male	17-Jan-24
11	Iskwe	Ibrahim	Accepted	Male	18-Jan-24

Sheet: Data

You could move the status to the end if you dont want it "visible on a printout
Then just change the Gender filter

In B4:

=SORT(FILTER(CHOOSECOLS(Data!A2:E12,1,2,5),(Data!C2:C12="Accepted")*(Data!D2:D12="Male")),3,1)

In B18:

=SORT(FILTER(CHOOSECOLS(Data!A2:E12,1,2,5),(Data!C2:C12="Accepted")*(Data!D2:D12="Female")),3,1)

Glad to have helped.

If that takes care of your original question, please choose Thread Tools from the menu link above and mark this thread as SOLVED.

Also, if you have not already done so, you may not be aware that you can thank anyone who offered you help towards a solution for your issue by clicking the small star icon (* Add Reputation) located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of each of those who offered help.