function isolateEmployeeData() {

 var sheetNameToWatch = SpreadsheetApp.getActiveSpreadsheet().getSheetByName(SHEET_NAME);

 var columnNumberToWatch = 2;

 var valueToWatch = "name1";

 var sheetNameToCopyTheRowTo = "Name1";



 var ss = SpreadsheetApp.getActiveSpreadsheet();

 var sheet = SpreadsheetApp.getActiveSheet();

 var range = sheet.getActiveCell();



 if (sheet.getName() == sheetNameToWatch && range.getColumn() == columnNumberToWatch && range.getValue() == valueToWatch) {

   var targetSheet = ss.getSheetByName(sheetNameToCopyTheRowTo);

   var targetRange = targetSheet.getRange(targetSheet.getLastRow() + 1, 1);

   sheet.getRange(range.getRow(), 1, 1, sheet.getLastColumn()).copyTo(targetRange);

 }

}