If you have a value appearing in the same cell in multiple worksheets, then you can summarise these values in a separate worksheet.
For example:

=SUM(Sheet1:Sheet5!B11)

- will add all the values that appear in cell B11 on all worksheets from Sheet1 through to Sheet5