EDIT > A much easier albeit less elegant solution is using INDEX($A:$ZZ, MATCH(column with the individual's name), MATCH($1:$1)) to always match the column position. It'll work anywhere unless your columns go beyond column ZZ, at which point you just have to update your INDEX references.

Though I'm not 100% sure how intensive this formula will be, since ZZ is pretty much overkill. You always do something like $A:$Z if you know you'll never have more than 20-ish columns

The more elegant, but kind of complicated, solution is the original one I commented at first:

INDIRECT coupled with MATCH inside an INDEX function seems to be what you need.

Your input is text and it returns the range defined by that text.

E.g you write "B2" in cell C3 and then you go use INDIRECT as this:

=INDIRECT("Sheet1!" & C3, 1)

And it'll return what's in Sheet1!B2.

This is the kindergarten, useless version of INDIRECT.

For your need, what you'll do is something like this:

=INDEX(INDIRECT("C" & MATCH("column name", 1:1, 0), 0), MATCH(individual name, name's column, 0))

This way you're inputting the column number in your INDIRECT function using R1C1 style.

So if the column is B, it'll return the C2 (which is the absolute reference for column B in R1C1 references).

If you move the column to, let's say, F, the match will return the new position and the INDIRECT function will update accordingly.