On sheet 1 of my workbook Column A contains 400+ unique values. Each of these values has a worksheet within the workbook that shares the same name.

For example, cell A2 on Sheet1 could be called 'Tiger' and cell A3 could be called 'Bear'. I need to create a hyperlink for each 'Tiger' and 'Bear' to cell A1 of a worksheet of the same name.

I understand how to create add a hyperlink on a cell by cell basis. I am hoping that there is a more efficient way to complete this task. Is is possible?