I have a spreadsheet with a different tab for each team, and lots of people on each tab. I'm trying to design a 'search' tab, whereby a user can input somebody's name and click search, and it will automatically locate which tab that staff member is on and automatically swtich to the correct part of the correct tab. Is there any easy way to do this? Thanks in advance.