Counting details from multiple sheets

Friends!

Like the subject entails, that's pretty much it.

I have three sheets and another for summarizing these.

Basically, the sheets are about test drives committed during the month.

In the summary sheet, I would like to count how many test drives are done by each sales executive and count the number of vehicles used.

The summary table is divided into three section of dates, each count is to be returned into its section of the table using formula.

I hope the file is self-explanatory.

Please do let me know should there be any more clarity required to explain.

Thank you very much in advance!