vba working like a sumif

I have a spreadsheet with employees and the type of work they did each month. So for each employee for each month he will have a number of days and type of work.

I need to build a summary table for each of employee. I need it in a vba because I have a bunch of dates and a bunch of different sheets (1/company). So I need a tool that I can modify easily to expand dates and companies.

Here is an example sheet: real simple with only 3 employees and 3 months and 4 types of work. I need the vba to create the summary as shown at the bottom of the sheet.

if you can show me how to do it for this small sample then I can expand it to read the real data.