Paperwork Tracker

Afternoon,

I want to be able to use excel to track the submission of monthly paperwork.

I have a workbook with names, addresses etc and a column for each month of the year with a YES/NO drop down.
This master list is updated to say "YES" in the appropriate column when the paperwork is submitted.

I want to be able to populate workbook for each month with the entire row from the master sheet if there is a "NO" in the corresponding month column, from which I can run a merge to remind employees that they have not submitted paperwork.

I am aware that this topic has been discussed many times, however I am unable to find anything that I can get to work.

Any help would be greatly appreciated.

Thanks
Matt