=SORT(
    QUERY(
        {'Design Team Assignments'!B3:G;'Mechanical Team Assignments'!B3:G;'Programming Team Assignments'!B3:G;'Communications Team Assignments'!B3:G;'Media Team Assignments'!B3:G},
        "select Col1,Col2,Col3,Col5,Col6 where Col1 is not null",
        0),
    3, TRUE)

where Col1 is Not Null

where Col1 <>''