Sum across multiple worksheet

[leeksleeks]

Hi,

I have multiple workbooks that all have 7 worksheets within them with varing names. I want to sum the same range across all worksheets but how do I select these 7 worksheets without defining the worksheets name? There is only ever 7 worksheets. This has stumped me and I am yet to find an example of this on any forum so any help is welcomed.

Thanks in advance.

 

[Aladin Akyurek]

See:

https://www.mrexcel.com/forum/excel-questions/119020-sumif-multiple-sheets.html#post587456
https://www.mrexcel.com/forum/excel-questions/119020-sumif-multiple-sheets-2.html#post3308987