I want to use a formula in a cell (fixed), that contains a cell as reference
which in turn is subject to "move" by sorting.

The column containing the formula in lets say A1, HAS do be moved (sorted),
but the formula in cell Q8 (fixed there) should always refer to the value
that was formerly in cell A1 and might now be in A5.

This row 1 is part of a table that gets sorted. The line, that contains the
value (in row 1) to be used in cell Q8 contains some fixed text, that never
changes. Might this help?
(Maybe something similar as "COUNTIF")

Any suggestions?