I need to build a macro that can read through a list of file names and return the number of worksheets that are present in each of the file (this is an audit mechanism to ensure that the correct number of worksheets are present in a series of files created via another process). The macro would need to establish the path of the folder where the files are located (all in the same folder), then locate the first file, identify the worksheet count, and repeat for the next file etc. For example the file requiring this functionality looks like:

wkshtcnt.PNG

I thought I could do this with a formula by simply referencing the file names but I believe Excel does not have a straightforward formula for worksheet counts.
Thanks!