Keep comments column correct after refreshing data columns

I have an worksheet that refreshes every day from a .csv report.
I would like to be able to have a comments column at the end that users type in.
The problem is how to keep the comment next to the row it was on before the refresh.

When it refreshes there will be new rows, rows that are no longer there and all in a different order.

There is an Order Number column that can be used as an ID column.

I am not sure of the best way to go about doing this.
Any thoughts would be appreciated.