Finding the cell reference of a matching search value
 

I need to find a function or a series of functions, that will allow me to:

1. Search for a cell containing a particular string value (eg Cat)
2. Then have the function return to me the cell reference where the value
was found (eg C$2).

NOTE: The function needs to work across worksheets.