Linking data from a query to additional data

[Brumbot]

Hi all,

This post relates to one I have already made, but I decided that I hadn't properly defined what I wanted in the previous post:
http://www.excelforum.com/excel-prog...html?p=3159702

So, I have an ODBC query feeding into an excel spreadsheet that pulls data in every time I refresh it. I want the user to be able to add data into columns alongside the queried data, but whenever I refresh it at the moment, the order of the data is not retained. Is there a way I can fix the order of the data so that the data that is entered always refers to the data it was initially written next to. Ideally this would be done by creating another table I imagine.

Thanks in advance for your cooperation.

Example Workbook.xlsx

tldr;
The first tab, 'Raw Mats' is the queried data. I would like to add data in the columns to the right of it but maintain the order of it when it is refreshed.

[Brumbot]

Anyone with any ideas?

[Brumbot]

Bump. Still need help.

[Brumbot]

Bump still need help.

[Brumbot]

Still no-one with any ideas? I just need a tip in the right direction.