The name (string) of the relative name (e.g "TestName") is written in
Range "A1".
TestName itself is a named formula like "= SheetRef!A$3".
Purpose is to get always the value in row three of the correspondent
column.
When I enter "=TestName" in Range "F26" i will get the value of Range
"F3".
So, and now I'd like to use a formula, where I use the relative name,
which is entered
in Range "A1", something like =INDIRECT($A$1), but this doesn't work.
The idea is to use the values in column "A" for the relative names in
the INDIRECT function.

Any approach for a solution?

Regards
Werner