Dynamic worksheet reference

Ok, I am not an excel programmer. That being said... I have a dynamic drop-down list with names in it. I have worksheets that match the names within that list. I want to be able to select one of those names from the drop down and pull the data from the corresponding worksheet that is named the same as the entry in the list. I am truly at a stopping point until I figure this out. Please help if you can.

You can try to do so in a macro:

vSheetName = activesheet.listbox1.text
vRange = "A1"

vOutputRange = "C1"

activesheet.range(vOutputRange).value = sheets(vSheetName).range(vRange)

but you can do the same with a function if you prefer to avoid a macro.

Regards.
Antonio

Thanks for the reply. That reply went completely over my head and hit the wall. Like I said, I am not an excel programmer. I was trying to make it too hard. This is what solved my probelm in case someone else is looking for the answer.

B2 gets its value from the current worksheet...
B15 is a dropdown list of other sheet names...
F9 is the value I want to go get from the other sheet that is used for calculations on this sheet.

INDIRECT("'"&(INDIRECT("'"&B15&"'!$B$2",TRUE))&"'!$F$9",TRUE)