I think you want the INDIRECT function.

Example:
A1: 21
B1: ="A"&ROW()
C1: =INDIRECT(B1)

B1 will output the text string "A1"
C1 will output 21.

"Jon S" wrote:

For example if I would type, say, "A1" into a cell, for example B1, could I
then somehow extract the value A1 from B1 and use that information to point a
function at A1?