Calc users often select a group of related sheets and copy these sheets to another document.
In this case, in each copied sheet, the reference to the cell range of another sheet in the formulas is replaced with a reference to the cell range of the sheet of the source workbook.

Excel behaves differently.
If a formula on the copied sheet (A) contains a reference to a cell range of another sheet (B), then it is replaced with a reference to the cell range of the sheet of the source workbook only if the other sheet (B) is not subject to copying (not selected).

The same logic in Calc and Excel is applied in the case when the copied sheet contains a hyperlink to other sheets.

In my opinion, Excel's behavior meets user expectations, but Calc's behavior does not.

Suggestion: in the "Move/Copy Sheet" dialog, provide a parameter that will regulate the preservation of mutual references (hyperlinks) between the copied sheets.

The same for the corresponding ".uno:move" command.

In tdf#130180 it is suggested to replace absolute references to sheets with relative ones. But we should not change the Calc document from which the sheets are copied. In addition, for example, if the formula on the first sheet contains a relative reference to the third sheet (the name of the third sheet is specified without the "$" prefix) and we copy only the first and third sheets, then the reference after copying will contain an error value.