Merging data from multiple workbooks

[neilcarden]

Hi all, I want to merge data from information that is sent to us daily on a .csv. The data is on 8 columns, but we only need to merge the data from column C (however this isn't major as I can extract column C once all the data is in one place - but whichever is easiest).

So I need to basically at the end of each month get all the data off 30/31 sheets, get it all together on one sheet so i can then do some analysis.

can anyone help me write a macro to do this, I can do most of the stuff, its just getting the data in one place nice and easy that is giving me headaches.

Cheers

[arthurbr]

Ron de Bruin has some solutions here