Formula in Name Manager

Hello

Im having a problem with the use of indirect and name manager. The below formula from A9 in attached file is working perfectly (it shows a row in Sheet2 by the use of indirect from Sheet1):

=INDIRECT(A2&"!"&LEFT(ADDRESS(2,MATCH(INDIRECT("Sheet1!"&ADDRESS(3,COLUMN())),INDIRECT(INDIRECT("Sheet1!"&ADDRESS(2,COLUMN()))&"!$A$1:$F$1"),0)),2)&A6)

I added the red colored part of the formula into the name manager to use it dynamically and called it GetColumn.

But I cant seem to get the formula to work with the use of the named GetColumn, as this is not working: =INDIREKTE(A2&"!"&GetColumn&A6)

Can someone please tell me what im doing wrong here?

Thank you for the response, but I think you misread my problem. The formula works, I have it in A4 as well and it shows "$B" as it should. But I have the same formula in GetColumn in the name manager and I want to replace the formula with GetColumn. So in short, the formula will show "B" if put in a cell, but if the same formula is put in GetColumn in the name manager and GetColumn is used in a cell instead of the formula, it will give an error.