Google sheets query troubles

Struggling a little with a query function on google sheets.

i need to bring the data from the source tab into the tracker tab where 'Tracker A' matches 'Source C'

long story short..... source data is pulled from a sheet edited by 3rd parties and i my team need to add extra columns to this but the problem is when the third parties sort the data it throws it out of sync on my teams tracker.

Any ideas? my thoughts are to bring the whole of the source sheet to my spreadsheets and then use query to effectively line it up in my tracker sheet.