Search multiple worksheets for Text String, copy and paste entire row into new worksheet

I need to search multiple worksheets for a text string (Customer Name) I enter and then copy and paste the entire row of all matches into a new worksheet (ideally with the Customer Name as the worksheet title) for further analysis.

I have 18 worksheets in a workbook and the customer names are located in Column B of all the sheets. I have found threads with some similarities to my question but I don't know enough about VBA to understand how to edit the code to get what I need.

I am using Excel 2010 and am attaching a sample workbook. Try customer names Sam Spade, Mary Jones or Fred Smith to test.

Thanks for your help,

Steve