importing Data from cvs files to excel and perform some steps using macro

i want to import csv files into one excel file using a macro and perform some steps for example deleting some rows based on matching the date in two columns. some times the imported information will be very large (more than 1 million cell) and it will not be possible to collect them in one file.

Thanks in advance