That is excellent, thank you. If it is not optimal it is plenty good enough.

I had made one mistake in the description of the problem, though (sorry). I should have said:

If the formula is in cell S10, the formula should be =INDIRECT("'" & S7 & "'!D10"). (The name of the worksheet is always in row 7 of the same column where the formula is, and the row from where the data is extracted should be the same row where the formula resides).

Can you help me one more time? TIA,

Alex



>Hi Alex,
>
>I'm not sure if it's optimal but it works
>

>=INDIRECT("'" & INDIRECT(LEFT(ADDRESS(1, CELL("col"),4,TRUE),1) & "7") & "'!c8")
>

>
>>Thank you Sergey, that works. Now I need to make it generic :)
>>
>>That means that if the formula is in cell S10, the formula should be =INDIRECT("'" & S7 & "'!D8"). (The name of the worksheet is always in row 7 of the same column where the formula is).
>>
>>I tried to obtain this cell's column by CELL("col"), but that gives the column *number*, not the letter. Do you know how to obtain this column's cell letter?
>>
>>What resources do you recommend to become proficient at VBA (for Excel).
>>