Problem creating loop function to record each subject response in new Excel sheet

Hi,

I am currently writing a program which is meant to copy string responses into an Excel file and also responses on a Likert scale into another Excel file.

So I have been able to achieve this but the main issue which I am facing is that the data collected always goes into the first row and then the next time I run the script the previous data is overwritten by the new input rather than recording on the next Excel sheet which is I have been trying to do.

I want to create another function with a loop which gives instructions to record each new response from a participant further down the sheet but so far I have had no luck.

I am wondering if anyone has an idea of how to solve this problem or if they have faced a similar issue in the past and could tell about their experience?

All the best,

Trevor