Lookup Name in 3 different workbooks

[mtndewgradon]

I have a main list of names on one spreadsheet and I have 3 other spreadsheets that I need to see if these names are on them. If they are on a sheet, I need to know what sheet it is on. Each name can be listed more than once on the other sheets. I tried multiple vlookups with IF statements but I could not get it.

I have attached example worksheets. Any help would be most appreciated.

[p24leclerc]

see attached workbook.
In column B, you have a formula that will give you only one of the sheets' name where the name is found.
In column C, D and E, you have individual formula for every worksheet you might have.
Remark that the worksheet names are fixed in the formula.
You might have to open all of the files at once to synchronise the formulas in Main List sheet.
Hope this helps