More information is needed about the layout of the information in the
worksheets with the names (are names all in a single cell as [Firstname
Lastname] or are they in separate cells as [Firstname] [LastName]). Also
what are you thinking of in terms of "results" of the searches? Count of the
occurances of a given name, or the names and associated information? Can the
same name(s) appear more than once on any given worksheet? That kind of
thing.

Bottom line answer is this can be done - whether it can be done easily with
worksheet formulas or needs to go on to VBA code to accomplish has yet to be
determined.


"Charles" wrote:

How can I have Excel search for specific data, such as a person's first and
last name, through a range of cells in a range of worksheets in the same
workbook? And, how can the results of that search be figured in a separate
worksheet?