data relationship

[westconn1]

at intervals i am sent a .xls spreadsheet, with updated pricing
the data also includes cross references to equivalent products in columns F to howevermany, see sample
this workbook contains 37k lines, may vary in different versions, as shown not all lines have cross references


in many cases the a lot cross references have been dropped from later versions of the data, so i want to record all cross references from the different versions, before the information is lost

i need to either bring the xrefs from each version into the latest workbook or else possibly set up an access database, with a simple vb6 front end, and import any additional xrefs from new versions when they arrive

any suggestions for setting up database tables to link all equivalent items
or
copy all the cross reference into the current workbook, so that all the xrefs are applied to each other, when looked up from the UI sheet
note in rows 2 and 3 several of the xrefs are the same, so effectively item 2 and 3 should xref
all items in the xref columns should also be in the item column, with xrefs to the same items

i can use ADO to select all items on sheet with xrefs, but need some ideas to process the data and store