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?