Concatenate to get formula

[t1968]

Hello All!
Does anybody know to concatenate texts and values from different cells to get a valid working formula?

To illustrate:
Let's presume I have cells with values "Sheet2", "!", "B", and "2". How can I concatenate these to behave as if it were a formula =Sheet2!B2 to get data from cell B2 in Sheet2?


Any suggestions would be appreciated.
Thanks and best regards,
T.

 

[Scott Huish]

Assuming your cells were A1:D1

=INDIRECT("'"&A1&"'"&B1&C1&D1)

although honestly I would hardcode the ! instead of putting it in a cell.