Multiple CountIf functions in a VBA Script

Hello everyone!

I have two sets of workbook where worksheet A contains a full length data and worksheet B is a summarized table version of workbook A.

As of now, I incorporated the Count-if functions on workbook B that captures data from workbook A. Each cells in the table are using different criteria in its Count-if function. I have attached the file that you can view to get a better understanding of how the file looks like.

I know that excel functions are useful but I would like to see if I can shift it towards VBA. I just started learning VBA and it would be great if I can get a head start from you guys here on the first cell of the table. I will pick it up myself once I manage to understand how the script will work. Let me know if there's anything needed and thank you so much for your help!