I have tabs in a workbook for every year, 2003 to 2007. Each sheet is a list
of employees who have had an <event during the year. Some have 2 or more
<events in a single year.

I want to add a new sheet with a master list of all employees and insert a
lookup formula alongside each one to search each sheet returning every
<event and the date associated with it.

A vlookup will only return one event per employee, per sheet. It will not
find multiple <events???

Need some help please.

Thanks.