Using pandas to create links between spreadsheets

Question

I'm working on a small project and in it I have to link cells from other spreadsheets (T1, T2, T3...) in a spreadsheet (we can call it consolidated). They all have the same size and shape.

Follow the instructions available here: here but without success

with pd.ExcelWriter('Consolidado.xlsx', mode='a', engine='openpyxl', if_sheet_exists='replace') as write:         
    wb = write.book
    ws = wb['Plan1']
    ws['A1'].hyperlink = "T1.xlsx#Sheet1!A1"

Basically I have to do the following: In the consolidated worksheet cell.Sheet[A1] I have to leave an active link to T1.Sheet[A1].

In Excel it would be ='path[T1.xlsx]Sheet1'!A1

When using the code above, the following result appears

"T1.xlsx#Sheet1!A1"

and when I click, I am directed to another spreadsheet. But the value that is in this other spreadsheet should appear to be added to the formulas below.