Array for B3:

=IFERROR(INDEX('Raw Announcements'!$C$1:$C$10, SMALL(IF(INDEX('Raw Announcements'!$A$1:$A$10&'Raw Announcements'!$B$1:$B$10=$A$1, 0) + INDEX('Raw Announcements'!$A$1:$A$10&'Raw Announcements'!$B$1:$B$10="All", 0), ROW('Raw Announcements'!$C$1:$C$10), ""), ROW(A1))), "")

Array for B11:

=IFERROR(INDEX('Raw Announcements'!$C$1:$C$10, SMALL(IF(INDEX('Raw Announcements'!$A$1:$A$10&'Raw Announcements'!$B$1:$B$10=$A$1&"Manager", 0) + INDEX('Raw Announcements'!$A$1:$A$10&'Raw Announcements'!$B$1:$B$10="AllManager", 0), ROW('Raw Announcements'!$C$1:$C$10), ""), ROW(A1))), "")


Copy down, the copy to other sheets, then delete the ALL sheet.