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