Hello,
I am new to this forum and am self taught in Excel (and the crowd cringes). I have a workbook with 5 worksheets. The first tab is a table of contents for the other 4. Each of these four worksheets consists of four columns (by about 50 rows) of data. The column A consists of numbers starting with 1.01 in cell A3 and on this page goes up to 1.33 in cell A35. Column B contains text that relates to company policies. C and D contain further descriptions and are not really relevant to my question. The same basic format is followed on the remaining worksheets. What I need to do is create a table of contents on page one that mirrors column A and B (I will go back and truncate some of the text in B, but again, not really relevant). I want to place a hyperlink in cell A that links to that same cell (1.12 in the TOC tab links to 1.12 on tab #2) but I don't want to have to do this individually for each hyperlink. That's how I started and it will just take too long. I tried the HYPERLINK formula but I must be missing something because it won't work for me. I need to handle this without using VBA if possible.

I hope that's enough info. I tried to be thorough. Any help is appreciated!

If this has already been answered could someone just post a link to the thread?