Counting Data From Multiple Sheets

Hello,

I was wondering how to go about this...

I have 5 columns of numbers located in columns T-X in each sheet that have been sorted and counted.

I want to then, on the final sheet, count how many times each number occurred in ALL of the sheets for that specific column, and how many times each number occurred overall between the 5 columns.

On the final sheet, column 1 would be referring to column T, column 2 would be referring to column U, etc..

Also, if that number doesn't exist in a column or even at all, I would like to have a 0 placed in the cell on the final sheet. Could this be accomplished by setting a range of numbers before it begins counting?

Any form of guidance would be greatly appreciated.

I am using Microsoft Excel 2007, and I have attached an example document to help provide a visual of what I am trying to achieve.

There are currently only three sheets in my example document. The first two contain the numbers and the third sheet would be the sheet to total them in.

Thanks in advance,

w3dgie