Best Practice For Synching Data from Linked Table w/ External Data

I have a linked table where I copy data in from an external source on a monthly basis. The external data changes between updates in that new records could be added or existing records could be removed. I am trying to determine the best way to update the data I am using in Airtable so that it stays current and doesn’t break the existing linked and lookup fields.