Search spreadsheet for text entered into cell and copy row of found text to new row.

Need to search spreadsheet for any text string entered into a set cell then have entire row copied to new row. If multiple rows are found then multiple rows need copied.