I have set a spred sheet that has hyperlinks to other sheets. In doing this I
have also set the cell name to change to the name of the sheet. I need to
make a formula that refers to the newly created worksheet at specific cells.

Example I have a worksheet named Test1

In my master worksheet (MasterA3) I have a Hyper link cell that will take me
directly to this page that gets its name from the Test1 worksheet.

In cel MasterA4 I need to refer to Test1C3.

I would like to get the name of the page (`test1'!C2) by refering to MasterA3.

I assume I will have to use some type of nested formula, How can I do this?

Thank you.