I am looking for a formula to accomplish the following:

I want to search column A of a worksheet for a specific trxt string. If that
string is found I want to copy the data from that same row to a second
worksheet.
For example I am looking for "Widgets" in column A of Worksheet1. When it
finds "Widgets" in cell A250 I want Excel to copy and paste cells B250, C250,
D250, etc. into worksheet2.
Does anyone know if there is an easy way to do that?