I have a worksheet that exports results from one sheet to another based on
what is entered. It currently only returns results for a specific month and I
need it to return results for several months, upto the previous year or
current year.

I'm wondering if I'm asking the question wrong as this will be the third
time I've asked. The other two times I didn't receive any responses.

The following is what I currently have in my results sheet.

Inputs in A1:A3
In C2:
=IF(COUNTA($A$1:$A$3)<3,"",IF(AND(Sheet1!A4=$A$1,S heet1!C4=$A$2,Sheet1!G4=$A$3),ROW(),""))
In D2, copied to I2:
=IF(ROWS($1:1)COUNT($C:$C),"",INDEX(Sheet1!A:A,SM ALL($C:$C,ROWS($1:1))+2))
In J2, copied to M2:
=IF(ROWS($1:1)COUNT($C:$C),"",INDEX(Sheet1!S:S,SM ALL($C:$C,ROWS($1:1))+2))
Select C2:M2, copy down to cover max expected extent of source data in
Sheet1. Format cols to taste. All lines satisfying the criteria inputs in
A1:A3 will appear neatly packed at the top. Try changing the criteria inputs
to a different set, it'll return accordingly.

Thanks so much in advance for any advice you can offer!!!