Link returned recordset with a user entered column

I have a worksheet that is the result of a sql query. The recordset returns:

Col A: Item number, Col B: Desription Col C:Cost Col D:Category

The users insert a new column (E) and input their sales prices agains each item.

However, new items are regularly added to the source db and details such as the cost price and category sometimes change and I need to return the new items to the worksheet. So far everytime I update the records it throws the Col E results out of alignment because item numbers are not sequential and there is no index I can use in the database.

Can anyone suggest a better way of handling the linking between the returned recordset and Sales price?

Does my question make sense?

Bump. no response