I guess i am facing same issue, Someone shared a master sheet ( suppose A1:F9 ) with me and I used importrange function to make a private sheet. I have used immediate next coloum to F i.e.,G to make the required changes.

Now what s happening is, if the owner is deleting say A6 row then G6 is not getting deleted plus A7 data is appearing in A6... which in turn shuffles the data by showing G6 ( previous and current same ) with updated A6 (previously A7 ) data.. making the sheet more chaos

same happens while adding the row in master sheet

any suggest about how to deal with it ?