Can anyone help me how to search the data in column by its keyword???

I'm using Excel2007 and I'm doing a database, i have a lots of concerns and questions, let me start with this.

I have two sheets, the first sheet is the search sheet, then the second is the masterlist. I want to have a search button than can actually search for its key word and filtering the others. (This is searching if filtering by its keyword)

This is the Scenario for example my text box for search is Sheet.range(A1).value
and my search button in First Sheet.

then in my Second Sheet i have my database this are the following data

(collumn 1) (collumn2) (collumn3)
(row1) MS-00 Test One A Mark Twain
(row2) MS-01 Test Two B Sherlock Holmes
(row3) MS-02 Test Two A George Bush


if type a value in my Sheet.range(A1).value and click the search button like Holmes then the whole row2 will appear and the other will be filtered or hide


like this...
(collumn 1) (collumn2) (collumn3)
(row2) MS-01 Test Two B Sherlock Holmes


or if type a value in my Sheet.range(A1).value and click the search button like Two then the whole row2 and row3 will appear and the other will be filtered or hide

like this
(collumn 1) (collumn2) (collumn3)
(row2) MS-01 Test Two B Sherlock Holmes
(row3) MS-02 Test Two A George Bush


Please Help!!!
Thank you in advance....