from openpyxl import load_workbook
wb = load_workbook(workbookEx.xlsx)
ws = wb.get_sheet_by_name('sheet1')
link = 'workbookEx.xlsx#sheet2!E5'
How to create a hyperlink to a different Excel sheet in the same workbook