https://www.pbainbridge.co.uk/2023/03/switch-view-to-specific-google-sheet.html

Switch view to a specific Google Sheet.gs

function switchActiveView() {

  // get spreadsheet
  var ss = SpreadsheetApp.getActiveSpreadsheet();

  // get cell range in destination sheet that the view will be switched to
  var range = ss.getRange('Sheet2!A1');

  // activate cell range so cursor moves to that position and changes the current view
  range.activateAsCurrentCell();

}


function onOpen() {

  SpreadsheetApp.getUi()
    .createMenu('Admin')
    .addItem('Switch view', 'switchActiveView') // label for menu item, name of function to run.
    .addToUi();

}