The hyper link should go to the other sheets(sheet1 or sheet2). where the text is present.