=INDIRECT(A1&"!A2")
--
David Biddulph

"Pedro Serra" wrote in message
...
In an excel file with multiple sheets (for instance sheets name's A and B)
is
it possible to use in sheet A in cell A2 a formula like =A1!&A2, where A2
is
a in sheet B and A1 is in sheet A and as the tab name (B) written. The
formula should return the value in cell A2 of sheet B.

Thanks in advanced