You could use AutoFilter with the custom filter Contains "north" (no quotes).

If you want a spreadsheet formula,
Put this in row1 of the sheet "North" and fill down.

=INDEX(Data1$A$2:$A$11,SMALL((100-(99*--(SEARCH("north",Data1$A$2:$A$11&"north")<LEN(Data1$A$2:$A$11))))*ROW(Data1$A$2:$A$11),ROW()),1)

This is an array formula entered with Cmd+Return (Windows version, Ctrl+Shift+Enter)