You will have to remove the code which is being used to "clear contents" on the existing sheet. Also, while pasting, you need to read the content already existing on the sheet and paste data below it. Use End(xlUp).row and paste the data one row below it.
Accha sikhaya but data appending kese karenge. Means data daily ek ke niche ek paste hona chaiye (Offset)?
You will have to remove the code which is being used to "clear contents" on the existing sheet. Also, while pasting, you need to read the content already existing on the sheet and paste data below it. Use End(xlUp).row and paste the data one row below it.