Right function for formula not result

I have a list that is not consecutive therefore it may jump from needing to read from cell4 to cell15 in rows 3 & 4 so referrring to an existing formula that reads from the correct row seems to make sense.

I have the formula =Sheet2!C2 in Sheet1!P2, in Sheet1!R2 I would like to have a formula that finds the value of the same row but a different column.

i.e. in column R
=Sheet2!C2 becomes =Sheet2!F2
=Sheet2!C15 becomes =Sheet2!F15.

I was thinking a formula with =Sheet2!F and concatentating the last character of the P cells formula but it gives me the result of the formula.

Any idea how this can be done?

I don't seem to be able to get this to work

Or I don't understand the formula well enough to manipulate it for my needs?