I will try to explain this the best that I can...

I have around 100 excel workbooks that contain the same exact sheets in
each. In each of these worksheets there are cells that contain a number
value that I would like to total on one 'master' sheet. These workbooks are
in there own folders but the workbooks all have the same name. As time goes
on there will be more folders and workbooks created that I want to total
without having to change the master.

Is there a way to count the value of a cell from these workbooks and not
have to be concerned if there are additional workbooks added? I was thinking
of some type of VBA or script that could run and go out and search these
folders for that file name then count the cells...

Is there a better way to do this? Thanks in advance.