Google Sheets – Organize Data Range into Single Column

Please try something like:

=query(importrange("https://docs.google.com/spreadsheets/$$$$","Applicant Form Response!A:G"),"Select * where Col7 = 'Pass' ")  

where $$$$ is whatever is appropriate to complete the URL for your source (access to which you will need to grant).

function onEdit(e) {
  var sheet = e.source.getActiveSheet();
  var sheetName = sheet.getName();
  if ( sheetName == "Sheet1" || sheetName == "Sheet2" ) {
    var r = e.source.getActiveRange();
    if (r.getColumn() == 4 ) {
      var col = r.getColumn();
      if ( col >=  6 && col <= 100 ) {
        sheet.getRange(r.getRow(),8).setValue(new Date());
      }
    }
  }