I know there are 100+ scripts out there for searching, but I have not found one that can search all worksheets for a keyword and bring all rows containing that keyword onto a new worksheet. If the term is in multiple instances within a row it should still only bring that row into the new worksheet once. However, multiple instances within a column should be sure to bring each row containing that keyword into the new sheet.

Style points if the new worksheet is titled the name of the search term such that running multiple searches keeps things organized.
Also style points for an 'exact' checkbox option that looks for the keyword as a stand-alone word as entered vs. looking for the search term buried within words. Ie. with box unchecked 'ham' returns rows with 'Birmingham'
Even more style points for color-coding the search term within the new worksheet.

If I've missed this (I've spent quite a few hours looking) please point me in the right direction. If you can help with a script, kudos and I imagine others would reference this in the future also.