Need formula to output multiple data in one cell from workbook

Hi - I have the attached vacation calendar workbook with a single tab per employee showing the year in full where they input vacation on a particular date. I would like to have each person's name output on the corresponding monthly tab. I have created an IF statement yet can only get one name to output.

Employee tab: Al -- January 4th, cell E12 = "8V"
Employee tab: Godshall -- January 4th, cell E12 = "8V"

HAVE = Monthly tab: January -- 4th, cell D7 = '=IF(Al!E12<>"",Al!E2,IF(Godshall!E12<>"",Godshall!E2,""))' = Munther Al
WANT = Monthly tab: January -- 4th, cell D7 = formula unknown = Munther Al, Susan Godshall

Ultimately, I would need the formula to IF through all blue employee tabs to check the same cell corresponding to the dat and output their name. If you can help me get through more than one employee tab and output more than one name, I'll take that and work on extending the formula.

Thanks in advance for your help with this!

Just wanted to confirm - are you still on V2003?

try this:

=IF(Al!E12<>"",Al!E2,"")&IF(Godshall!E12<>"",", "&Godshall!E2,"")&IF(Banta!E12<>"",", "&Banta!E2,"")

YES, THAT WORKED!! Looks like the only change is the '&' between IF statements...okay, that is fabulous!! Thank you so very much!!

I'll mark this as SOLVED and excellent rating!