VBA to create hyperlink on each cell which display detail of other sheet

Hi All,

I need to check all the details in master sheet when clicking on any ID from child sheet through hyperlinking (or any alternative). I am able to do manually for only one row but can not proceed when 1000 of row are there in the child sheet. Doing manually will take lots of time. Is there any alternative approach or developing a macro can automate this process.

e.g. from the attached sheet, when I click on value '92315' from child sheet, it should select the entire row from master sheet when matching ID. If not match, it should say 'not matched'