If the worksheets you want to add are consecutive (there are no 'other'
worksheets between the first and the last), =SUM('First Sheet:Last Sheet'!A1)
(replace First Sheet and Last Sheet with the appropriate worksheet names, and
A1 with the cell you want to add. (If you really do want a count of the
cells rather than a sum, use the function COUNT where I've SUM).

"OB1" wrote:

I want to know the total of all counts of a specific cell from over 100
different excel worksheets. It is the same cell on each sheet. Don't want to
have to open each worksheet.