We run several daily performance reports. The files are created by day of week with a DOW identifier built in. All of the files are structured the same way, (columns, headers, etc) but with varying number of rows per day.

I need to create a macro that will open each of the daily CSV files, extra all the data under the header row (1) and append to a single worksheet. The number of rows will vary but I need it to then open the next CSV file and append that data beginning in the first empty row so I can compile a full week of data in a single worksheet.

If you need the info, the CSV files are named CSVAR1.csv, CSVAR2.csv, etc through CSVAR7.csv and the Workbook is CSVARIANCE.xls and the data sheet is named Data

Thanks for any assistance.