One way:

If the combined info is in cell D1:

=INDIRECT(D1)

In article ,
Jon wrote:

Okay here is my question, and I'm sure its basic.

I've got 3 drop down boxes that when chosen return a value.

The first drop down box returns a sheet number,
2nd returns a column letter
3rd returns a row number

In a 4th box I have a cell that combines all the text so it reads something
like:
Sheet2!B17

I want a cell to display the value in that cell.

So if I have a cell with the text in it, Sheet2!B17, how do I get an
adjacent cell to display the value that is contained in that specified cell?
This will be dependant on what the text in that cell is, and subject to
frequent change.