Formula to Exclude lines that dont match criteria

Hi,

I have a spread sheet that has a master visit planner on sheet 1 and then monthly sheets. I have entered formulas to extract the monthly data but cannot figure out how to exclude lines that do not meet the criteria.

I've attached a sample sheet which hoperfully makes things a little clearer.

Thanks in anticipation of your help

Chris