Allow 2-way linking of cells across different tabs in the same excel worksheet so that updating information in one cell will update information in the other and vice versa. Allow these links to persist even in auto-filtered lists.
If allowing: Menu/Tools/Options/LibreOffice Calc/Iterative references doesn't work for you, I think that is not going to happen. https://help.libreoffice.org/latest/en-US/text/shared/optionen/01060500.html?DbPAR=SHARED#bm_id3149399