Create a List using IF(AND from other tabs

[SFCChase]

Is it possible to create a list using data of a different tab using an IF(AND formula?

I have 3 tabs. My first tab (Firers) has 4 columns (Rank, Name, Date, Iteration)
My 2nd (27SEP) and 3rd (28SEP) tabs have 3 tables each (Iteration 1, Iteration 2, Iteration 3)
Basically I'm looking for a way to auto-fill the 3 tables on 27SEP and 28SEP by searching the date, iteration columns on my Firers tab. If Date = 27FEB AND Iteration=1, that rank and name get added to table. The same formula will be used for Iterations 2 and 3.

I will have a list of about 250 names on the Firers list.


Thanks in advance

 

[Fluff]

Is the date on the Firers sheet an actual date, or is it text?

 

[SFCChase]

It's an actual date

 

[mikerickson]

Advanced Filter with the Copy To Other Location option can create the tables, but updating them dynamically would be a problem.

 

[Fluff]

Assuming that 27FEB is a typo & you meant 27SEP, you could use this formula for the 27SEP iteration1 table
=IFERROR(INDEX(Firers!B$2:B$8,AGGREGATE(15,6,(ROW(Firers!B$2:B$8)-ROW(Firers!B$2)+1)/((Firers!$C$2:$C$8=DATEVALUE("27/09/2019"))*(Firers!$D$2:$D$8=1)),ROWS($A$1:$A1))),"")
Filled down & across