The formula I provided simply looks for a match of your ID in the other sheet, and returns the corresponding value from the column referenced in the Match() part.

So if you sort the sheet, the Match() will recalculate based on the ID in the same row.

You will need to do the same for any of the columns that you have that directly link to a a cell of another sheet.

Again, you will need to convert the index columns to text entries as 1.1 and 1.10 are the same thing if left numeric... you just background formatted it to look different.