Find a number of strings within a worksheet and move them to another.
 

Guys and dolls this has to be straightforward, I just can't figure out
the best way to do it.

I have a spreadsheet of clients.
I am looking for a number of different strings that could be part of
the content in any of the fields (columns) specifically "deceased"
"died" "dead" etc.

If the string exists anywhere in the row I want to move the whole
record to another workbook, the first column of which should be
populated with the string that has been found (so that I can filter on
this later).

Can anybody point me in the right direction please?

Thanks,
Martin