Count the occurence of a value across multiple worksheets

Greetings! I'm Tim, and I'm just an average Excel user who found his way here through Google. I did a little poking around and this looks like a great community. Maybe I can contribute on future visits.

I'm wracking my brains over this one but I can't seem to get anywhere. What is easy on a single worksheet becomes a conceptual nightmare when extended across multiple sheets........

I have an Excel 2007 workbook with ten worksheets, each is 5 columns by *about 50 rows. My column headings are the same on each sheet. All of the cells are formatted as Text.

Here's an example of the data:

Sheet 1, Column C:
aaa
bbb
ddd

Sheet 2, Column C:
bbb
bbb
aaa
ddd

Sheet 3, Column C:
ccc
bbb
ccc

I need to know how many times each value in column C appears across the entire workbook, and I need the results to be inversly sorted by the number of times that each value appears.

Here's an imaginary result drawn from the data above:
'bbb' = 4
'aaa' = 2
'ccc' = 2
'ddd' = 1

Can someone help me out of this mess?