Formula across several sheets with variable names

Is there a way to use formula (Sum in this particular case) across multiple sheets with sheet names having a particular criteria?

The sheet names are 5 digits but not sequential (cost centre numbers). I'm trying to find the total if the sheet name (number) falls within a particular range (e.g. 150xx-152xx, 153xx-168xx), with around 60 or so sheets in total.

I know it's possible to specify the range myself, or to add a blank sheet as a marker/guide to create a "sandwich" of the required sheets (e.g. =SUM(Start:End!A1)), but the cost centre ranges may change if they're changed so I'm trying to find a way to identify them as variables rather than requiring maintenance.

Although the layout of the sheets should not change (and so a macro might work..?) I think I'd prefer to find a formula (if possible) so anyone using it can see what's going on


Can anyone help, please?

Hi, if you want to identify them as variables and use a formula you need to use =INDIRECT()

I don't think you can use indirect as a "3D" function (across multiple sheets, so you would need to do:
=INDIRECT(A1 & "!A1")+INDIRECT(B1 & "!A1")
and so on, where A1 and B1 are your sheet names.