indirect worksheet references

[elias tauscher]

I have created a workbook with several end of month worksheets.
I analyze data putting together in a different worksheet of the same
workbook data from different worksheets.
If I put in R1C1 the name of a worksheet and in R1C2 a different one,
how should I input the data as to reference different worksheets
changing the contents of those cells ?
It looks as I should use INDIRECT but I cannot get the right syntax.
Thank you

 

[Peo Sjoblom]

Something like this?

=INDIRECT("'"&R[-2]C[-2]&"'!R[-1]C[-2]",FALSE)

depending on where you put the formula, it is easier if you use the A1 type
of references

=INDIRECT("'"&A1&"'!A2")