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.