Google Sheets user interface doesn't include a way to locate a sheet by name.
At the bottom there is a tab for each sheet, but they aren't sorted alphabetically and some sheets could be hidden; also there is a button that shows the list of sheets shown and hidden but this list isn't sorted either.
Google Apps Script could be used to find the sheet. I.E. the following script activates a sheet having the name
var name = 'Sheet1'; // Change Sheet1 by the name of the sheet that you want to find
var sheet = SpreadsheetApp.getActiveSpreadshet().getSheetByName(name);
Google Apps Script is very powerful, it includes prompts to ask the user to write the name of the sheet to look for, also includes the HTML Service that could be used to create custom dialogs and sidebars.