So to sketch the picture highlevel.

Lets say I have a folder in which I have 10 zip files.
All these zip files contain 1 csv file.

Now I want to loop thru all these 10 zipfiles, open them, open the csv file (comma delinited) and copy the data in a new excel sheet.
So the new excel sheet collects all the data from the csv files (the all have the same columns) that are in the zip files.

Then save the collection as 1 excel file.