VBA Array w/multiple search criteria

So I've spent a few days trying to sort this out, but am not having much luck. On the surface this seems to be an easy enough premise. I have table of data. I need the table to hide certain rows depending on what the user punches into the search box. If they search for "Sam", any row not including "Sam" is hidden. However, best case scenario would be that the user could punch in more than one variable, and it would filter even further - "Sam 2011" etc. I've found vba scripts that come close to what I'm trying to achieve... but nothing close enough to superficially edit. Any help/direction would be greatly appreciated!Sample.xls

That is almost perfect. The only downside is that it can only filter by one of those three variables at one time. I found a similar way to accomplish that working earlier, but destroyed it unintentionally while trying to alter it. Is it a limit of excel, or is there a way to modify the code to accommodate multiple variables simultaneously?

hi Jeepster325, please check attachment, insert value in B5, conditions should be delimited with space

That did it! Thank you both for the assistance.