Formula to find text on a page and return that cells name.
 

I have several pages each with cells having unique cell names. In each of
those cells is text names. I need to have a formula on a summary page that
will find the specified name say "bill", and return the cell name of each
cell on the other pages that say "bill". I cant use Hlookup or Vlookup
because the names could be in several places on the pages so I cant limit the
search to a specific table.
Is this even possible?
I can have a macro do it but would prefer a formula.

Thanks,
Kevin