Adding new data to a worksheet from a CSV file

Hi there

I'm using the current version of Office 365. I'm trying to add new data to a worksheet from various CSV files. The CSV's contain purchase history data that is exported from our accounts software (in the cloud). I have to export it in chunks of data as the software won't allow exports above a certain size, so I break it down into months.

I've tried adding each CSV to the same worksheet using the Import from CSV function but it always adds the header into the middle of the data which I can't delete. So at present I import it into a separate sheet then copy+paste it into the same sheet.

I'm sure there must be a more straight forward/easier/quicker way of doing this so I'm hoping someone here can help me find it.

Many thanks,
Andrew

Thank you.

I will give that a try later today.