Countifs,Indirect Function and Vlookup combined

Hi ,

Need your help on how I can combine the countif, indirect function and vlookup functions into 1 cell.
I have several sheet for each month, and 1 summary tab. I need to get the total number of VL for a specific employee, and for a specific month to be reflected in the summary tab, and data should automatically change everytime I change the month in cell C1(indirect function).

Also, if the employee is not in 1 of the sheets the summary tab should not get any error message.
I attempted many times, but just couldn't get it right....
Hope anyone can help me please....
Thanks in advance!!


For the month of July

VL Sick Leave Half Day Vacation Leave
Alcantara, Pia 0 4 1
Espiritu,Russ 0 4
Gonzalo,Glenn 0 0
Malsom, Jonalyne 0 0 1
Napoles,Kristen 0 0 VL
Viduya,Kristel 10 0 VL
Antipuesto,Carlos 0 0 VL