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).
>