Hello! I have many closed workbooks and would like to run a macro to open each one, count the number of line items and paste the total count into one cell in my Master workbook. Also, each one of the closed workbooks are in different folders:

Main Folder
Sub Folder1
Spreadsheet1
Sub Folder2
Spreadsheet2
Sub Folder3
Spreadsheet3

All spreadsheets have 2 tabs but only need the rows counted on "Sheet1" and all Sub Folders have only one spreadsheet file. The Master workbook is in the Main Folder. The Master workbook needs only this data: File Name of Spreadsheet and Row Count.

Any help would be greatly appreciated!!