You can change your code and add a hyperlink (range.hyperlinks.add) to cell A1 of that sheet. So then clicking a cell will take you to that sheet.