Billybobbonnet

function ConcatenateText() {
  const ss = SpreadsheetApp.getActiveSpreadsheet();

  // Define sheet names
  const overviewSheet = ss.getSheetByName("Overview");
  const prependSheet = ss.getSheetByName("Prepend");
  const datasetsSheet = ss.getSheetByName("Datasets");
  const appendSheet = ss.getSheetByName("Append");
  const exportsSheet = ss.getSheetByName("Exports");