Hi

If the sheets are all set up in the same format, you can create a front sheet (a blank userform), and then on that sheet use a grouped formula
=SUM('sheet1:sheet200'!AA101)
you can manually type it, or if you go tothe specific cell on the new grand total sheet, and start your sum,
=sum( then select the first worksheet, and the very end worksheet, whilst holding shift, then select the cell AA101, it will then total all worksheet for that one specific cell.
The only thing to be aware of, is that it will only sum the sheets between the two specified.

Adi