Populating data from a master sheet into sub sheets based on the month on google sheets

As the title states, I simply want to pair a certain month from my master sheet onto another sheet so that I can simply change the month from a drop down arrow and have the data automatically updated.

I have set up the automatic change for the date, week day using this formula:

=TRANSPOSE(ARRAY_CONSTRAIN(ArrayFormula(date($B$2,month(B3&1),1)+transpose(COLUMN($C$2:$AO$2)-3)),day(EOMONTH(date($B$2,month(B3&1),1),0)),1))

But I don't know how to pair the other data from the master sheet.

For example on the Master Sheet, it contains all months in a row. But I want to bring over the attendance rate, Satisfaction rate, and sickness rate based off of a single Month to have a monthly overview.

This is how I started but it's worthless if I switch it to June for instance.

=IF($B$3 = "MAY", 'Attendance'!B2:AI39)

It would be nice if I could add all of the IF statements together and separate them with a comma.

Any help is appreciated!

Thanks!!