Countif worksheet

Hi,

I have a workbook with multiple worksheets. One worksheet has a table with names of some of the other worksheets in Column A (from Row 2 downwards) and sequential numbers in Row 1 (Column B rightwards) as shown below. The highest number (i.e. x) in Row 1 is dynamic and can change depending on circumstances.

0 1 2 3 4 5 6 7 ... x
Sheet2
Sheet4
Sheet6
.
.
.

I would like to write a vba code that will count the number of values, corresponding to each value in Row 1 (I.e. 0, 1, 2, 3, etc.), in the last column of each of the worksheets listed in Column A. So cell B2 in the above example would show the number of zeros in the last column in Sheet2.

I will be grateful if you can please advise me on the best way to write this code because I have been finding it difficult to do so.

Thanks very much
Zeeshan