Hi so I have a strange issue and can't get my head around it.
i have data that is imported from other file to Tab 2 and in TAB 1 i have my main issue.

in the example below i have date in Colum A, B and C imported from tab 2 by using in Tab 1 the following formula: =QUERY('TAB2'!A:C)
Basically, it imports my files list and in Colum D and E i will fill in static date that i will be updating

Then in Tab 1 i will make Filters for all the columns and when i use ascending or descending i get different information on each rob so basically row A till C will be differently sorted than data in D and E the funy thing is if i colour does cells the colored cels stay in the same order as it should but the value of the cell is now different T-T
So here is my example:

Item 1 | Colour | ID 1 | Client 1 | Sold
Item 3 | Colour | ID 3 | Client 1 | Not Sold
Item 2 | Colour | ID 2 | Client 2 | Sold
Item 5 | Colour | ID 5 | Client 3 | Sold

And if i filter for example on based Colum A i will get the following:
Item 1 | Colour | ID 1 | Client 2 | Sold
Item 2 | Colour | ID 2 | Client 3 | Sold
Item 3 | Colour | ID 3 | Client 1 | Not Sold
Item 5 | Colour | ID 5 | Client 1 | Sold

But if i make the data in TAB 1 as static value and then use the filter formula it behaves as it should be.
Does someone know why or how this is happening?

Thank you in advance