I'm trying to find a function that will look at a cell and find the worksheet
that has the same name as the text in that cell and then report back a cell
from that sheet ie. if cell A1 is text "worksheet 3" I want the value in cell
B1 to be 'worksheet 3'!$D$12 but if the text is "worksheet 7" I want the
value in cell B1 to be 'worksheet 7'!$D$12 I then want to be able to copy
this formula down a list of 30 or 40 cells. Does a function exist to do this
or is it a complicted nesting situation.

Thanks for the help
mrengineer