Input message into cell from a cell in another sheet using data validation

Hello again super helpful people,

Please see my following code:

Please Login or Register  to view this content.

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!

You are awesome, works great!