Office Script to format raw data and export to csv

I am new with Office Scripts. Here is what I am trying to accomplish

getRange works when pasting from one sheet to next but not if getRangeByIndex

I am trying to understand why getRangeByIndex does not work when copy pasting from one sheet to another sheet

I am trying to understand why getRangeByIndex does not work when copy pasting from one sheet to another sheet

Here is the getRange