Search all worksheets and paste all rows w/search criteria to single sheet

Good day, Gurus.

I've got a workbook that I use for budgeting. Each month is kept on a new worksheet, and it already has about 50 worksheets. I would like to enter a word into an input box, have Excel search each worksheet for all instances of that word, and copy every row containing that word to the worksheet named "Search"

I haven't a clue of the best way to do this, and I can't write code, but can read it decently. Here's what I envision:

Sub Search()
Dim Ans 
Ans= inputbox, "What word or phrase are you looking for?"
For each worksheet in this workbook
search Ans
If row contains Ans then
Copy Row to bottom of "Search" worksheet
Continue until all worksheets have been searched
End Sub

If there is a better, simpler or more reliable way to accomplish my goal, I"m definitely open to suggestions. Thanks in advance for any help you can offer.

Hutch