Hyperlinking using VBA

[Christopherdj]

Hi

Can anyone provide me with a code to automatically create links from a "Summary" Sheet, to new sheets created in the same file.
The new sheets are named from data in column "O" of the "Summary" Sheet.

I presume the concept is like if the data in column "O" of the "Summary" sheet exists as an actual worksheet (as named from column "O" of the "Summary" sheet, then the links will be automatic.
If it helps, the newly created sheet also has the sheet name in Cell B1.

Is this possible?