Creating Monthly report

I thought this was going to be a simple solution but I am stuck. I have a spreadsheet where I am entering client information for private visits. I want to then make a monthly report where I am showing and tallying up that months total. I thought an index match formula would help me but that's not working. Then I tried creating a pivot table separating every month out and that also is not working.Will doing VB be easier? Can someone please guide me to the best solution. I'm attaching a sample spreadsheet to show you what I want.
Someone please help me.

Thanks,
Isara1