Google Apps Script (Spreadsheets). copy

gistfile1.js

function copy() {
  var src  = _retrieveBySpreadSheetBySheetName('sheet1').getRange('A1')
  var dest = _retrieveBySpreadSheetBySheetName('sheet2').getRange('B1');
  
  src.copyTo(dest);
}

function _retrieveBySpreadSheetBySheetName(sheetName) {
  return SpreadsheetApp.getActiveSpreadsheet().getSheetByName(sheetName);
}

gistfile2.md

sheet1

	A	B
1	data1	data2
2	data3	data4

sheet2

	A	B
1	data5	data6
2	data7	data8

result

	A	B
1	data5	data2
2	data7	data8