Formula needed to search in multiple sheets for a name, and if yes then sheet title will be listed

Hello!  I am not sure if such a formula exists in Excel... but this is what I would like to do...   I have an excel spreadsheet of employee training.  There are multiple sheets, all with the exact ...