VBA reference a cell in another worksheet

[tqn626]

I'm trying to get a code to work to put the link the another cell in a worksheet. I got a version of it working but it keeps erroring out when there is an Apostrophe in the name such as "Master's data"

This is how i wrote the code

"='" & Worksheets(i).Name & "'!" & Worksheets(i).Cells(3, 5).Address

I just want it to spit out this ='Master''s data'!D5

 

[My Aswer Is This]

If your talking about Vba code it would be something like this:
Cells(1, 1).Value = Sheets("Master's").Cells(3, 5).Value