how+to+get+the+contents+of+another+cell+with+a+formula+in+excel

example

=CELL("contents",A5)

see also how to evaluate a string in excel