Create a button in google sheet and link to multiple sheets through the script editor code

To create a button in google sheet and link to another sheet 

through the script, just follow the below steps.

First, open a google sheet, click on the main menu, Insert - Drawing

Select a Shape and desired Button and drag and create button

 

Now, once button created click on the three dots on the top right of the button

Click on Assign script (any desired letters)   

Now go to tool - script editor and delete existing codes. and paste the following code : 

function PC() {

  var selection = SpreadsheetApp.getActiveSheet().getActiveCell().getValue();

    var html = "<script>window.open(' paste url here');google.script.host.close();</script>";
    var userInterface = HtmlService.createHtmlOutput(html);
    SpreadsheetApp.getUi().showModalDialog(userInterface, 'Petty Cash');

}

Make necessary changes as per your target sheet requirement. 

For more details watch the video: -