Search specific column and then copy to new sheet

Hello again,

I need a way so that I can press a button and then a box will appear and allow me to type a search word. It will then scan a particular column if it contains that word and then it will copy the entire row and paste it into a new sheet.

It must be able to handle multiple search terms.

So: If I have multiple names like "John Smith" and then 20 rows down I have John Smith again and then another 10 times it has John Smith in that column, then it will copy the entire row in which john smith is within, (All of them) and paste them into a new sheet.

It should copy the entire row including the columns before, because the column where it is searching for will mostly likely not be column A.

Thank's again

~JSN