INDEX/MATCH Between Sheets

Hi everyone, I'm working on a personnel tracker readiness tool and I'm having trouble with Index and Match functions. I've tried VLOOKUP and got the same result so I'm assuming its something to do with the way I sent the tool up. I have attached the excel file and some images of the formula evaluation below. This tool has two sheets, one will contain basic data, names of people, etc. (names masked to the Alphabet for the forum) and the second sheet will contain a monthly calendar of availability. The First Sheet "Data" is only built up with the "Managers" column for now (A21 - A24). What I am trying to do is count every row in the calendar sheet in column A that contains a name from "Managers" and "AV" in Column D...I have this working partly.

The problem is that the formula only works for the first identified match and only in the row where the criteria was sourced from. So in the attached example the first match is "H" in A14 on the sheet labeled "Master". "H" comes from A22 on the sheet labeled "Data". The formula ONLY works in row 22 in the sheet labeled "Master" where I need it to work across all rows from 6 to 13. eventually I add a COUNTIF to sum up each occurrence of a name match with AV. But for now I just want to get the formula to work in the proper rows.

In the attached images, you see the INDEX MATCH result change from '1' to '20'. I'd appreciate any help to figure this out

Capture1.PNG

Capture2.PNG