Before I can advice anything, I have a couple of questions.

1. Why doesn't user enter new ID's and updates to existing ID's directly into main sheet? I.e. how are data processed?

2. What happens when there are new ID's or existing ones for updating entered? Are entries on main sheet updated somehow?

3. When main sheet is updated, what happens with data (used to update) in other sheets afterwards?

4. What happens, when existing ID is entered as new one? Or when non-existing ID is entered for updating?

5. Can there be cases, where existing ID must be deleted?