VBA to create Hyperlink to sheet based on Cell value

Hi,

Recently I have a following case:

I have a huge list of accounts (vertical list) in one worksheet and also have the huge number of worksheets in the same workbook.

Each sheet has name which corresponds to the account list. for example:

Column A
11111
22222
33333
44444

and also have the sheets named with 11111, 22222, 33333, 44444

What I need to generate in column B the hyperlink next to each account in column A its corresponding sheet.

I assume it can be done only using VBA code.


please support if possible.

The case is that I have a huge list of accounts and corresponding sheets, I will have to make insertion of links for each sheet and it will take a while.

Thanks a lot, worked perfectly