VLookup function to search an entire workbook
 

Is there a function to search for a given word in an entire workbook and
retrieve the information from that sheet into a different worksheet in a
different workbook? I'm fairly comfortable w/ how VLookup works...but am not
able to use it searching a workbood. I'm not very computer savvy...so if you
could really spell it out for me that would help.Thanks!