I am scraping daily data from a certain website then exporting the dat

I am scraping daily data from a certain website then exporting the data into a CSV file. I would like the data to be in one sheet instead of several sheets for each day how do I achieve this?