excel - A search that will return the name of all tabs in which a search string appears

Question

We have a spreadsheet that lists all of our company's Learner Roles. There are well over a hundred roles, each role has an individual tab (named for the role), and contains a list of courses necessary for the role, and the names of those in that role. What I would like to do is perform a search that would return the name of each tab that search string appears in...so if I searched for "Smith,John", it would return "Role1, Role7, Role12, Role57", telling me every role that John Smith is listed under. This would allow me to do the same for the courses, so I could get a list of all roles that a particular course shows up in.

Currently, we maintain a manual list of courses, with links to the roles, but this is far from perfect, and maintaining the employee names as well is too cumbersome. I can do a search with "Workbook" selected as a search option, but the resulting list is not recordable, and gives me truncated tab names

I am open to any solution...we currently access this online through a Sharepoint site, but if there's a good solution, I can apply it offline.

Thanks in advance, Jim

question from:https://stackoverflow.com/questions/65925150/a-search-that-will-return-the-name-of-all-tabs-in-which-a-search-string-appears

Answer 1

Waitting for answers