Numbers: Combine several tables into one

Question

I have a Numbers spreadsheet with a table for each room in our house listing jobs that need doing and a priority rating for each. For example:

Kitchen
Job                  Priority
Fix tap              1
Replace fridge       2

Bathroom
Job                  Priority
Replace cracked tile 3
Reseal bath          1

I'd like to create a new summery sheet which pulls all the information into a new series of tables based on their priority. For example:

Urgent
Job                  Priority
Fix tap              1
Reseal bath          1

Important
Job                  Priority
Replace fridge       2

Low Priority
Job                  Priority
Replace cracked tile 3

Is there a way to filter multiple tables like this?

Edit 7:10pm: I've discovered UNION.RANGES, which looks promising, but it only ever outputs the first cell of the unionised range. Is there some way to get it to fill the whole array into a new table?

Edit 11th December: Trying to use INDEX as follows to retrieve other cells from the array results in the error 'The formula contains a number outside the valid range.'

INDEX(UNION.RANGES(TRUE,Hall and Stairs::Fault:Estimated Cost,Dining Area::Fault:Estimated Cost,Utility::Fault:Estimated Cost,Lounge::Fault:Estimated Cost,Kitchen::Fault:Estimated Cost,Downstairs Loo::Fault:Estimated Cost),2,1,1)