I am trying to grab the data from a dynamic cell every week. All I’m needing help with is how to write a script that will continue to add this data week by week in a column with the date it grabs the data in the cell next to it both continuous as the weeks increase after it is created. I’m not a programmer I’m learning slowly in my down time but this would me help me automate a few things at work in the mean time while I work on more important things and learn more about programming.

Here is the link to a sample spreadsheet
https://docs.google.com/spreadsheets/d/1KW3FYDnTDKWZJd-JgtDKbE-cs_duA3GifPFvM_1TZp8/edit?usp=sharing

Here is the code I have been trying to run

function OperationsLegalData() {

  var PercentRange = SpreadsheetApp.openById(662281933).getSheetByName("Legal Data 13 Week Rolling").getRange("B3");

var Percent = PercentRange.getValue();





}




function theTimeTrigger() {
   ScriptApp.newTrigger('OperationsLegalData')
     .timeBased()
     .onWeekDay(ScriptApp.WeekDay.TUESDAY)
     .atHour(9)
     .create();
}

I tried to understand the programming with no underlying knowledge of it and got this far but need some guidance on what to do next or how to send the data to the apporpriate spots