What I’m telling you WILL result in separate files.
- generate filename with today’s date
- check if file exists
- if file doesn’t exist, create it with header row (you could actually do this by having a template Excel file with just the header row, and copying the file)
- append data to it
This process will result in a new file every day, that has the header row.