Add row into table - cell reference get moved after adding it

following issue:

i have an excel with several sheets.  (excel is located on onedrive)

sheet 1 contains a table which get populated with data coming from MS flow (add a row into table)

Sheet 2 references to  cells on Sheet 1  -->   e.g.   =Sheet_1!$B$287

the problem is ,that whenever flow addsa row, the reference on sheet 2 get changed to  =Sheet_1!$B$288

so how can i add flow data to an excelsheet and at the same time reference to these cells within other sheets ?

thank you

stefan