VBA loop through all the files in the folder and count the used rows

Looking for a specific solution trough VBA, We have multiple excel workbooks in a folder, Now we need to get the count from all of the workbooks individually (each workbook has mutiple sheets in them, but need the count only from sheet with name "Consolidated" from all the workbooks in the folder). The count should do minus 1 to ignore header count. Also folder selection option needs to be included. The out put file should give the file name and count of used rows.

Note: file name varies daily as it includes date in it, for example the file names are like
Daily Monitor Check 20160701
Daily Monitor Check 20160702
Daily Monitor Check 20160703

somebody from members please help on this.

Surely just a case of using DIR to get a list of files, opening each workbook in turn and getting the number of rows if the workbook should contain the sheet "Consolidated"...?

All very basic VBA stuff - any basic search ("vba list files in folder") will get you the outline code you need.

Thanks cytop, Got the codes online, however two issues I have noticed
1. The output sheet is coping column B from source wrkbook content to output sheet column B which is not needed. Please amend this in codes, as we just need file name and used rows count.
2. Count is giving total count minus one. We need exact count of used rows minus headers reference column A in source workbook.
3. Please add folder browse option in VBA, if we can to browse the folder and then execute the macro.

Please help in amending these two in codes to remove column b from output sheet and to get exact count, Iam very new to VBA, coould not get the correct line to amend, so please help. Attached workbook contains the VBA code.

Somebody, Please help in amending the code.

Tip: You'll get way more replies if it looks like you've made an effort and are trying to learn how to understand the code so you can edit it yourself rather than just asking for someone to do your work for you with no effort required on your part.

Thanks for the Tip, agree with you.