Spreadsheet to count outcomes of another spreadsheet every week

ive been set a challenge to create an excel document that will show me how many Y and N for a certain person each week.

We have a master Excel document, called Master. in this document there are 3 columns, name, date, and y/n.

I need to create another excel document that will let me, using a form, type in a name and select a week to give me results on how many Y for that person and how many N in that week, from the master document.

I hope this makes sense, I have attached two documents that will hopefully help.

Martin