My master data sheet has multiple instances relateing to when a product was
ordered. I need to create an order count in a second workbook by verifing
against multiple cells. Below is a short example...

** Master Data

Course Type Date
Salad apple 15-Mar
Salad apple 17-Mar
Salad apple 17-Mar
Salad pear 15-Mar
Salad pear 1-Apr
Salad walnut 10-Mar
Dessert apple 12-Mar
Dessert banana 14-Mar
Dessert banana 14-Mar
Dessert banana 2-Apr
Dessert mango 19-Mar
Dessert mango 22-Mar

** Reporting Data

Course Type Order Count
Salad apple
Salad pear
Salad walnut
Dessert apple
Dessert banana
Dessert mango

The master data sheet I am working with has more than 14000 lines and more
than 500 types, so entering in each type/course would be extremely
cumbersome.