macro for counting with matching criteria of two different options

Hello friends,
I'm kind of new to programmimg in excel & till now I was trying with help from internet.
but this problem is big for me to resolve, so looking for experts.
I need a macro which can count number of enteries based on matching 2 fields & pasting data in another sheet.
example: I need to count how many A101 has enteries of 3 clr, 4 wht & so on. same with A102 enteries & pasting data in another sheet in tabular form
A101 1 4 Wht Tghd
A101 1 4 Wht Tghd
A101 1 3 Clr
A101 1 4 Wht Tghd
A101 1 5 Gry
A101 1 5 Gry
A102 1 5 Gry
A103 1 5 Gry
I have attached example data(in Xls) which is very small(actual data will be pretty big), "tabular" sheet in attached example is the format I need.
so table needs to fill up all available materials (3 cle, 4 wht etc) & count number of these corrosponding to A101, A102... & so on.
Hope I was able to explain in detail.
thanks guys

You could just use a COUNTIFS formula which takes more than 1 type of criteria if you're sure the order quantity will always be 1. If not, then you can use a SUMIFS formula which sums using more than 1 criteria. Attached is an example of the countifs version.

Thanks for quick reply mate,
Yea I tried that option before, problem is number of different materials (3 clr, 4 clr, 4 Wht etc) are not certain for each table.
It can be sometimes more than 10 different products, so first thing is I need to put in unique products available only to first layout (like A101, A102),
so it should only list products available to that table & so on.
I thought may be macro for pivot table but not sure how to build macro for pivot table with matching 2 different criteria..