I'm trying to link one sheet to another using a hyper-link, however there are thousands of hyperlinks to do so I'm thinking the best way is some sort of automation.

I have one work sheet with a list of invoices numbers and various details, my other sheet has invoice numbers and other details about them but the second sheet is automatically created in such a way that it cant be organised in a way that I could merge the two.

So when I click an invoice number I need it to lookup that invoice number on the other sheet and take me to it.

Any help would be great

Thanks!