Help with Sorting a spreadsheet by month

So I've got a test file I'm working on and I'm stumped.

I need to filter and show results only from a specific month on Sheet1 when I change the drop down on A1

I already have a formula on the sheet but it calculates everything and disregards the month based on the roster in the Dump sheet.

Any help is appreciated. Thank you

in Sheet Dump in G2 and drag down;

=MONTH(F2)

In Sheet1 in C3 copy across and down

=COUNTIFS(Dump!$D:$D,C$2,Dump!$E:$E,$B3,Dump!$G:$G,MATCH($A$1,Dump!$A$2:$A$13,0))

Sheet1

C3=SUMPRODUCT((Dump!$F$2:$F$100<>"")*(MONTH(Dump!$F$2:$F$100)=MONTH(Sheet1!$A$1&0))*(Dump!$E$2:$E$100=Sheet1!$B3)*(Dump!$D$2:$D$100=Sheet1!C$2))

Copy across and down

Thanks for the help! I actually solved it by adding another criteria for months on the countifs