open csv files, do time stamp difference and paste result

Hi guys, you all were such help last time I hope you can help now.

What I am trying to do is the following:

I have a folder with some .csv files, it can be 1 or 500 files, how many there are vary.

I need to write a macro that will open each csv count the number of rows ( excluding the first row) and put the total in column G of my active sheet.

The results need to be ordered by basically the file name, by that I mean, if I have 3 csv files named A, B, C, the results in column G should be in the same order from top to bottom.

Thanks!