Change formula with dropdown list

[MinerExcel]

I have a dropdown list of all the sheet names in my workbook. I have similar values in the same cells of each sheet. Is there a way that I make a formula or a macro that will use the dropdown list value to select the correct sheet to pull the data from?

 

[Aladin Akyurek]

Insufficient information as you don't tell the cell of the dropdon list and the target cell which houses a value that you want to retrieve.

Let A2 house the dropdown list. Let E4 = the target cell.

In B2 enter:

=INDIRECT("'"&A2&"'!E4")

Is this what you intended?

 

[MinerExcel]

That returns #REF! My drop down list in cell E13 contains the names of other sheets in this case it's "Half Inch Clean" E16 is the target cell.

 

[MinerExcel]

Nevermind, I typed it in wrong it works!

 

[Aladin Akyurek]

Nevermind, I typed it in wrong it works!

That's great.

 

[MinerExcel]

Thank you very much I had never used indirect before.