Referencing a cell in another worksheet

[KennyG2000]

In a formula, Is it possible to reference a cell in another worksheet other than hardcoding the name of the worksheet?

E.g. =TabTwo!D11

Is there a way to replace TabTwo by a reference to a cell, assuming the text "TabTwo" can be found in cell A10 in the current worksheet? Would concatenation or indirect work (I tried, but could not make it to work)

Any suggestion will be greatly appreciated. Thanks! /Kenny

 

[VoG]

Try

=INDIRECT("'"&A10&"'!D11")

 

[KennyG2000]

It worked! Thanks! /Kenny