Find and Link duplicate in workbook

[cauciu]

I have some duplicate data (column B), which are located a different sheet.
I want to find the duplicate data then create a link to the duplicate data in column C (value=name of sheet).

For example in attachment.
I want find duplicate data (sheet1) on workbook (sheet1, sheet2, sheet3).
if duplicate found, value of column c (sheet1) will be set to name of sheet we found duplicate data (sheet2) and when i clicked, it will be go to cell we found duplicate.


please help me
linked.xlsx

[Teethless mama]

Sheet1:

C1: =IFERROR(HYPERLINK("#Sheet2!B"&MATCH(B1,Sheet2!B:B,0),"Sheet2"),HYPERLINK("#Sheet3!B"&MATCH(B1,Sheet3!B:B,0),"Sheet3"))

[cauciu]

Thank you for helping me.

[Teethless mama]

You're Welcome!