Display the "Defined Name" of a cell in a cell when the cell reference is in a cell?

Hello,
I created a scenario summary and in the Result Cells column, all I get is a cell reference.
Is there any way I can do a look up of that cell number located in the other tab called "PPM3..." so that the "Defined Name" of that cell in "PPM3" displays where I wrote the "?" in the "Scenario Summary" tab??

I've been searching the web for days, no luck, maybe I am not asking the right question, but I think it should be doable, right?
I also downloaded the Kutools toolbar but I don't think that would help.

PS: I don't know how to do macros, so if your solution involves a macro, please keep that in mind when explaining to me. I am willing to try anything as long as the steps are clear :-)

Thanks so much in advance!