# refers to ThisWorkbook. So when you use # in hyperlink formula then it check for the sheet within the current workbook