def linkCells():
    wb = load_workbook(filename='output1.xlsx')
    ws = wb['Summary']
    cells = []
    for row in ws.iter_rows():
        for cell in row:
            temp = re.compile("([a-zA-Z]+)([0-9]+)")
            res = temp.match(cell.coordinate).groups()
            val1 = res[0]
            val2 = int(res[1])
            if val1 == "B" and val2 >= 25:
                cells.append(cell)
    for val in cells:
        cellCordinate = val.coordinate
        temp = re.compile("([a-zA-Z]+)([0-9]+)")
        res = temp.match(cellCordinate).groups()
        val2 = int(res[1])
        cellValue = val.value[:30]
        link = "output1.xlsx#" + cellValue + "!A1"
        ws.cell(2, val2).hyperlink = link
        ws.cell(2, val2).style = "Hyperlink"
    wb.save(filename='output1.xlsx')

从我的角度看，你只想要做这个：
```python
from openpyxl import load_workbook
from openpyxl.worksheet.hyperlink import Hyperlink
xlfile = "output1.xlsx"
summary_sheet = 'Summary'
wb = load_workbook(xlfile)
ws = wb[summary_sheet]
cell_coord = 'A1'
for row, sh in enumerate(wb.worksheets):
    if sh.title == summary_sheet:
        continue
    hyperlink = Hyperlink(target=xlfile,
                          ref=cell_coord,
                          location=f'{sh.title}!{cell_coord}'
                         )
    ws.cell(row, 1).value = f"{sh.title}"
    ws.cell(row, 1).hyperlink = hyperlink
wb.save(xlfile)

<details>
<summary>英文:</summary>
Seems to me all you want to do is this 

The output file has 4 links in column A for each of the Sheets 1-4. If you click a link it will move the focus to cell 'A1' of the selected sheet in the workbook.<br>
 
[![Example output Excel file][1]][1]
  [1]: https://i.stack.imgur.com/L2N1B.png
</details>