rows don't follow unique value

Guys, I need help with an Excel issue.
I have a master sheet with an auto-updating formula that pulls unique rows by ID from 3 other sheets.

The next columns contain dropdowns (data validation) and comments that users manually update. Once they select a dropdown, the formula is replaced by a value (can’t avoid that).

The problem: when new data is added to the source sheets, the formula refreshes and inserts new rows in the middle, but the dropdowns/comments don’t move — they stay on the old rows and no longer match the correct ID.

Is there a way to make each row (including manual dropdown values) follow its unique ID when the formula updates?