Update value in external workbook when location cell in original workbook changes

[CLibre]

In Calc How to automatically keep the referenced cell value in an external workbook updated when the cell referenced, in the original workbook, is moved?

The source workbook has a cell value that changes daily and depending on other updating within the source workbook, the location of that cell changes too. There is an adjacent cell on the same row, with a short description that stays with the cell containing the value.
What is the best way to accomplish this?

Version: 25.8.1.1 (X86_64)
Build ID: 54047653041915e595ad4e45cccea684809c77b5
CPU threads: 6; OS: Windows 11 X86_64 (build 26100); UI render: Skia/Raster; VCL: win
Locale: en-US (en_US); UI: en-US
Calc: CL threaded

Thanks in advance for any assistance with this.

[sokol92]

@CLibre

There is an adjacent cell on the same row, with a short description that stays with the cell containing the value.

A standard solution for spreadsheets is a named range.
In the source workbook, add a named range with a reference to the cell containing the total.
In the target workbook, add a formula with a reference to the named range in the source workbook.