Sounds like this is a data blending issue, if I understand correctly that you are using multiple sheets. Easiest solution if you only have one row per ID in each sheet is to literally merge them into one sheet. You could do that at your source before even importing.
I'd suggest watching this: Data Blending
If that doesn't help try and attach a .twbx so we can look more closely at the issue.