variable as sheet name in function

[theDrew]

Hi guys! In a function like this:

=sum('Session 2'!AB3:AB61)

is there any way to replace the sheet name (here, Session 2) with a variable? I have to build 10 sheets of dummy variables; all of these sheets will have the same structure but will pull data from different sheets. If someone knows how to do this, it will simplify my life greatly!

Thanks!

Andrew

 

[Juan Pablo González]

Yes, if you put for example the sheet name in A1

=SUM(INDIRECT("'" & A1 & "'!AB3:AB61"))

 

[theDrew]

that works, thanks!! :D