Hi. When I wrote "I have a workbook that has worksheets named A,B,C...Z." I
was generalizing. The actual names of the worksheets vary. For example

Jan 2(2)
Jan 3

Does that help in troubleshooting your suggestion ?

"T. Valko" wrote:

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.