Hello again super helpful people,

Please see my following code:
For I = 1 To (Worksheets.Count - 1)
Cells(I, 3).Select
ActiveSheet.Hyperlinks.Add Anchor:=Selection, Address:="", SubAddress:= _
        "'T" & I & "'!A3", TextToDisplay:="='T" & I & "'!A3"
    With Selection.Validation
        .Delete
        .Add Type:=xlValidateInputOnly, AlertStyle:=xlValidAlertStop, Operator _
        :=xlBetween
        .InputMessage = "'T" & I & "'!A4"
    End With
Next
So I have a bunch of worksheets and I made a table of contents. In column C, I made hyperlinks to each of the sheets. The text displayed in column C is equal to the text for each respective sheet's cell A3. I also want to insert a rollover message. However, when I use my current code, the text that displays is 'TI'!A4' (where "I" is the sheet number) instead of what is in the respective sheet's cell A4. It works properly for the A3 text, but I can't seem to get the A4 text working.

Any help is always much appreciated!