Macro to count rows in files that seats in another folder

[amitcohen]

Hi All
I have a folder 'ClientsData' that contains over 200 files.
Each file have an average of 21 rows of data. (some more..some less..)
The data seats in column A only.


I have (separate) an Excel file that contains the list of all the files that in 'ClientsData' folder.
The file names are all in "A:A".

I need a macro to check each file in the folder and
store the number of rows that each file have, in Column B.

Any suggestions of how to do that?

Many thanks for your help
Amit