Quick Update

I currently have all documents I need saved as separate sheets in a single document. What would be ideal at this point is a formula (maybe some kind of vlookup?) That searches for all instances of a particular value (in this case, an exact-text match of an email address) across multiple sheets. Does this exist?

Thanks!