INDEX array formula using multiple criteria, * and INDIRECT references, Can it work?

[whetu]

Hey guys/girls,

I have been working on trying to pull payments from worksheets, that get generated each month, within my workbook. This is the formula I am using to pull the data (date-column1 and payment-column 2) but it can only use a single criteria, $F$3. I am using INDIRECT to reference different worksheets and ROW references that track down a helper column beside Column F.

=IF(ISERROR(INDEX((INDIRECT("'"&$D28&"'!A:F")),SMALL(IF((INDIRECT("'"&$D28&"'!F:F"))=$F$3,ROW((INDIRECT("'"&$D28&"'!F:F")))),ROW(INDIRECT($C28))),2)),"",INDEX((INDIRECT("'"&$D28&"'!A:F")),SMALL(IF((INDIRECT("'"&$D28&"'!F:F"))=$F$3,ROW((INDIRECT("'"&$D28&"'!F:F")))),ROW(INDIRECT($C28))),2))

What I would like to achieve is the above formula operating with more than one criteria.

Instead of only looking for the value in $F$3, I would like it to INDEX values from $F$1, $F$2 OR $F$3.

For example (and this does NOT work):

=IFERROR(
INDEX((INDIRECT("'"&$D28&"'!A:F")),SMALL(IF(

((INDIRECT("'"&$D28&"'!F:F"))=$F$1)*
((INDIRECT("'"&$D28&"'!F:F"))=$F$2)*
((INDIRECT("'"&$D28&"'!F:F"))=$F$3),

ROW((INDIRECT("'"&$D28&"'!F:F"))),ROW(INDIRECT($C28)),""),ROW((INDIRECT("'"&$D28&"'!F:F")))),ROW(INDIRECT($C28))2),"")

As you can see I have also tried to use IFERROR as well..

Thank you in advance for any help.

This is a stripped down version of the workbook.

FEES TRIAL DUMMY.xlsx

Whets