Seach and Copy Macro

Hi everyone,
Its been a long time since I have had to do this so I am a lot rusty on Creating Macro's.

I have 2 that I am interested in creating, the first:
I would like to, from a command button, click it, and a text input box appears, input the text you would like to search for in Column B (from sheet 1), if found copy the whole row and paste it into a different worksheet.

Here is the Macro I have tried to play with to get this, it obviously isn't right but it has some of the characteristics I want...
It has the search and copy criteria good (it searches in Column B if the correct work sheet and it pastes the whole row, if that word is found, into a different worksheet....)
What it doesnt do, and I'm hoping you all can help with is..
1) It doesnt incorporate a textbox and use the value of the inputted text in the text box to search.
2) It only searches the value (in the case that I am pasting now "empty"). I would like it to search if it has that string of characters in the cell at all....like "empty box", not just if it says "empty" only.. I am not sure I am saying this correct...it should copy and choose that row to copy, if the word (or string of characters) I input appears anywhere in that cell (in the whole of column B), not just the exact and only word in there.
3) If possible, that it take you to that work sheet automatically after you got it to search for you

Please Login or Register  to view this content.

The other macro I would like to create, is I macro, based on a command button, that deletes the information that was just populated by the original macro, and takes you back to the original sheet.

Thank you guys for taking a look at this and hopefully helping me out, its much appreciated

OK so i got it to incorporate an Input box now, and the value that was inputted....Except, it still is based on if the Value of the cell is exactly what I inputted...I need it to choose if the cell contains that string of charcters I inputted in the input Box anywhere within that cell.....Here's what I got...

Please Login or Register  to view this content.

The discoloured line is where I believe my problem to be,
I would really appreciate any Help here