Question about combining data from multiple tables

Hi, My problem is a bit complicated, but I suspect that the solution isn't too difficult. I have 3 tables, on 3 different sheets in my workbook. They contain a list of data with one column "priorit...