I have here Sheet 1 that has an ID number I enetered manually.

Sheet1

What I would like to do with this ID number is to link to Sheet 2 selecting the same ID number/s. Whenever I click on the ID number of Sheet 1, it will automatically show Sheet 2 selecting the cell/s of the same ID number/s I clicked on Sheet 1. Sheet 2 may have duplicates and it should select the same IDs. If there’s no duplicate, then it should just select one cell of the same ID.

Sheet2

What I only know is to use the link function of Excel to go to Sheet 2 which does only show the whole Sheet 2.

Sheet 1 Linking to Sheet 2

Help is greatly appreciated.