I have a large amount of data across multiple worksheets, the worksheets are not uniform in column or row number or column names (the data is from a variety of different sources!). I'm trying to create a macro to produce a search box and search all the worksheets for keywords that might appear in any cell and when found to then copy that entire row into a new sheet "Results". The search string is preferably for multiple words so that the search only needs to take place once. The aim of the macro is to provide a way for different offices to search for information that only they need so for example:

Office A - searches for cats
Office B - searches for cats & kittens
Office C - searches for dogs

The different offices can't be relied on to filter or individually search all the worksheets and I don't know exactly what each office is searching for to produce the results for them so this seemed the best way to search in a comprehensive way and to produce the data that they can then use themselves.

I've been playing with this for a while and searching the site for tips and suggestions but haven't been able to create anything that functions in the way I need it to across multiple sheets. I can either get the search-box working or a single search-word function or the results sheet - not all of them working at the same time. Any suggestions on how to do this would be really appreciated...