Not sure that is the best subject, but this one is a bit odd.
In Cell A1, I have a string that is another cell, for example A1 has "C5" in it. I want to be able to reference the value that exists in "C5", but from A1. So it might look something like the following?
Sheet1.Range("string that is in A1")