Please help with reading specific range without sheet number

[ppr (Peter Preuss)]

Duplicate of:

ASAP help on reading specific cell range and adding them together

Hi, any idea how to read specific cell range in all sheets and add them together? Basically just like read range without indicating the sheet number. Thanks

In general it could start like this:

retrieve all work sheets
iterate over the found worksheets
read in Excel worksheet