Hi,

If B1:D1 get their values from the corresponging cells in the target
sheet,

=INDIRECT("'"&$A$1&"'!"&ADDRESS(1,COLUMN()))

If you want a specific cell in B1 (say K24), then:

=INDIRECT("'"&$A$1&"'!K24")

HTH
Kostis Vezerides