Add up based on given values - VBA

Dear Friends,

I am tied up with many issues while programming for a bigger project.
Kindly refer to the attached excel file.

Column named 'CSQ Name' contains the call center descriptions for various departments and vehicle franchise.
I need a report that has only CSQ Names that end with 'FORD', 'JLR', POC' and 'FM' (valid ones). Rest are ignored.
In a particular valid CSQ Name say 'CEN-ENG-SAL-FORD' I need to know how many 1s are read in the 'Disposition' column. Plus I need the total count for both dispositions, 1 and 2.
The above should be done for all valid CSQ Names.

Kindly advise how I would go about it using VBA.
I need the most efficient method, as this is just a part of a bigger project and involves 70,000+ rows.
Sample result report also shown in 2nd sheet.

Much appreciate any help in this regards,
Philip