Try this:

A1 = A
A2 = B
A3 = C
etc

Enter this formula in B1 and copy down as needed:

=INDIRECT(A1&"!L1")

Biff

"carl" wrote in message
...
I have a workbook that has worksheets named A,B,C...Z.

I have a worksheet where ColumnA lists the worksheet names.

Is there a formula that I can use in ColB that will look at the worksheet
name in ColA and return the value in Row1, Col12 of the relevent worksheet
?

Thank you in advance.