[ajs8140]

Is there a function to automatically reference a certain cell on -all- worksheets?

For example: Taking the sum of cell A10 on -all- worksheets, irregardless of if subsequent worksheets have been created yet.


Any help would be great. Thanks!

 

[etaf]

if you put a worksheet named "first" and "last" and all other worksheet are put in between then

=sum(first:last!A10) should work

any names will do start, end

but the sheets do need to be in between