Get All Sheet Tab Names in Google Sheets

Here is a simple bit of Apps Script you can use to get the names of all your tabs in Google Sheets.

/**
 * Gets all sheet names in worksheet
 *
 * @return Each Sheet Name
 * @customfunction
 */
function getAllSheetNames(){
  return SpreadsheetApp.getActiveSpreadsheet().getSheets().map(x => x.getName());
}

Then simply use this formula in your sheet:

=getAllSheetNames()

Hope this made your Google search a bit shorter, leave a comment if this helped or you have any specific problems you need a solution to.