I'm attaching a sheet that sums (in Cell A1 of Sheet6) the contents of Cell A1 in each of the five preceding sheets.
Here's the formula that accomplished that: =SUM(Sheet1:Sheet5!A1)
It's not clear, however, whether that's what you're looking for. And frankly, although that shows that it's possible to do something like summing all the A1 cells, I'm curious what your bigger picture is, what all those individual sheets are about, whether it's even necessary to have multiple sheets.
Would it be possible for you to post a copy of your actual workbook? If it contains proprietary business info, create a mockup using fictitious data.