DynamicImportRange("https://docs.google.com/spreadsheets/d/1VPRKwdnciJCvpgsDZdub_JKcHr_VllMVKJhfK8Ub6lI/edit#gid=1308473687", "Responses", "B2:f45")

function DynamicImportRange(sheet_url, sheet_name, sheet_range) {
  var values = SpreadsheetApp.openByUrl("https://docs.google.com/spreadsheets/d/1VPRKwdnciJCvpgsDZdub_JKcHr_VllMVKJhfK8Ub6lI/edit#gid=1308473687").getSheetByName("Responses").getRange("B2:F45").getValues();
  return values
};

/**
*/
function RefreshSheet() {
  // Update the following two variables to suit your particular situation
  var sheet_name = "Priority";
  var range = 'B2:f45';
  var sheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName(sheet_name);
  var formula1 = "fLoading...";
  var formula2 = sheet.getRange(range).getFormula().toString().replace('"', '"');
  // The following assumes that the data is being inserted into the sheet in the same
  // location as it is in in the source sheet.
  var form_range = formula2.split(",")[2].split(""")[1];
  sheet.getRange(form_range).clear();
  sheet.getRange(range).setValue(formula1);
  Utilities.sleep(245);
  sheet.getRange(range).setValue(formula2);
};