Hi there

Wondering if someone has a macro which scans through all cells in all
worksheets and if it finds a cell which has the same value of one of
the sheet names, it then converts that cell to a hyperlink to that
sheet.
For example, assume you have sheets names Sales, COS and GP and in the
sheet Sales, cell A3 contains the text COS. It should then make this a
hyperlink to the COS sheet.

Thanks