Supposing in one of the cells in Sheet 1, I type in 'Apple1' in any of the
cells. Now, what I'm trying to accomplish is that if I type in 'Apple1' in
any cell in any of the other sheets, a hyperlink is automatically created
whereby if i click on 'Apple1' in the first sheet, it will directly link me
to the sheet where I just typed in 'Apple1' again.

What I am trying to accomplish instead of preset hyperlinks, I wanna create
it such that only if i type specific data, then would a link be automatically
created linking me to an item with the same name.

Is that possible?