Count number of rows of all files in folder

Hi Guys,

I need a method of accessing all files within a folder to get the number of rows/records and contents of "A2".
The file could ideally look at the current folder it's in and collect the requested data.

Hopefully I can work and develop the code to suit.

Regards

Resul