Count if + match with multiple criteria across couple sheets

Hi all,
I've got a problem and can't really figure it out the formula. I really hope You gonna understand what I'm trying to say.

I have a sheet which is called: Leave Tracker, in Row 7 i've got dates.
leavetracker.jpg

Then i have a second sheet which is called: Daily Staffing. The formula showed below counting me how many 'FT' codes are in column that matches with DailyStaffing B2.

{=COUNTIF(INDEX('Leave Tracker'!$B$9:$NI$485,0,MATCH($B$2,'Leave Tracker'!$B$7:$NI$7,0)),"FT")}

daily staffing.jpg

Then i have a 3rd sheet thats called Employee Data, where i have all data of my users.
employee data.jpg

So i've figured it out how to count how many users are matching criteria (date and code "FT"), but I need to add a second criteria which is gonna be "CORE" from sheet Employee Data.

Any ideas how to solve it? I was trying to add a second INDEX,MATCH but as an output im getting only REF or SPILL.

Thank You all in advance!