Search for a string and if found, select that row?

I know this is a very simple question but I can't find the answer I need. I am using Excel 2007 but I can get to a computer with Excel 2010 if necessary.

I have a spreadsheet with 42 columns and at least 5500 rows. In one column is a lot of text. I want to select all the rows that do not have a specific word in that column and delete them. If that's hard, then I could select all the rows that have that word and copy them into a new sheet.

Here's an example of what I want to do.

My table:

Name Dogs Fenced yard Dog types Oldest
Venus 3 Yes Poodle, Sheltie, Bulldog 15
Mars 2 Yes Shih Tsu, Yorkie, Poodle 12
Ares 2 No Yorkie, Great Dane 3
Zeus 3 Yes Rat Terrier, Border Collie, Saint Bernard 7
Hera 1 No Poodle 14

Goal: to keep all rows that have either poodl

I want to keep the rows that have the word poodle and move it to a new sheet. It would be even better if I could select the rows that had either the word poodle or the word yorkie. In that case I could just delete the others.