Tables not maintaining row relationships

[cableTIE]

Hello,

I have a worksheet that has four columns of data on it that I've formatted as a table with headers.

The data in the columns comes from two other worksheets:

Col A : <data validation : list from worksheet 1>
Col B : <index(match()) from worksheet 1, based on Col A>
Col C : <data validation : list from worksheet 2>
Col D : <index(match()) from worksheet 2, based on Col C>

Each row is then a "record", i.e. A/B/C/D:1 all relate to each other.

The data populates the table fine, but if I use the table headers to arrange the table data (e.g. sort A->Z), the table seems to rearrange itself randomly - the column selected isn't A->Z and the row contents become mixed. I can't see any logic or pattern to the way the table is being arranged by the filtering - do I have to set up the headers in some way to tell them to affect all columns at the same time?

Any help would be very much appreciated - I'm quite keen not to have excel outwit me (again!)

Thanks

 

[cableTIE]

Hello,

I'm shamelessly bumping this back to the top again - I hadn't realised how many posts went up on this forum in one day!

Any thoughts will be very much appreciated,

Thanks