Google-sheets – How to import the whole sheet to another Google spreadsheet

There are a couple of ways to do that. First, you need to declare the spreadsheet:

var ss = SpreadsheetApp.getActiveSpreadsheet();  

Secondly, declare the first sheet like this:

var sh0 = ss.getSheets()[0];

or like this:

var sh0 = ss.getSheetByName("Robin");

Then set the active cell and retrieve the column index:

var editedCell = sh0.getActiveRange().getColumnIndex();

And do the logic for the sort:

var columnToSortBy = 1;
var tableRange = "a2:I30";

if(editedCell == columnToSortBy){   
  var range = sheet.getRange(tableRange);
  range.sort( { column : columnToSortBy } );
}

Complete code, a bit shortened:

function onEdit(){
  var sh0 = SpreadsheetApp.getActiveSpreadsheet().getSheets()[0];
  var editedCell = sh0.getActiveRange().getColumnIndex();

  if(editedCell == 1) { 
    var range = sh0.getRange("A2:I30");
    range.sort({column: 1});
  }
}

You can use the following formula's in sheet2 (add them in A1 of course).

Formula

1. QUERY(Sheet1!A:D, "SELECT *")
2. SORT(Sheet1!A:D)
3. ARRAYFORMULA(Sheet1!A:D)

Explained

The last formula is the most straight forward, because nothing can be done in its current state. The other two allow you to do some tweaking, of which the first formula is the best equipped.

Example

I've created an example file for you: range reference