call a macro when user clicks dynamically created hyperlink on dynamically created sheet

Hello

My macro dynamically creates a sheet, and adds a hyperlink on a specific cell of that sheet.

The name of sheet and the cell with hyperlink will remain the same every time the macro runs.

Since the sheet will be dynamically created, how/where do i write the code to execute a macro when user clicks this hyperlink?

Thanks
Ajay