counting dropdown list with multiple text selections
 

What if I have a data validated drop down list is cell C7 that with in the
list the choices are Billy, Bobby, Cindy, Mike, and Randy.
There can be one picked from this list over a 1000 sheets within cell C7.
What is the formula to notate on an end sheet for the number of times each
on the the selections of the list were selected in cell C7 with the
corresponding cell C-7(not included in the 1000 selection for the number of
times each on the the selections of the list were selected.
Billy selected 100
Bobby selected 200,
Cindy selected 100
Mike selected 400
Randy selected 200