I have a spreadsheet with many differently named tabs.

On the first tab there are a list of names for client who work at different
offices.

I'd like to have a formula find that client's name on the following
worksheet tabs and then in a cell next to that name to tell me which tab the
record appears.

So for example:
On first tab: Michelle

The information for Michelle is on the Ohio tab

Can the formula go out and find Michelle's name on the Ohio tab and then put
the "Ohio tab name" in the cell next to her name?

Thanks!