For example, If we create a sales order and entered the quantity that updates the stock level to decrease the value in another sheet and then deleted the sales order or edit it, the updated field of stock level should reverse the previous update to increase back the value.
I think it is logical that this feature is exit otherwise values won’t be accurate in the database. This is normal that users forget to update manually every time they delete or edit a record that has linked field to other sheets.