There are several sheets in the workbook but only the values of the one sheet
(which also have the same name) are needed. The reason that they are
seperate is that these workbooks are being used as estimates for the company
I work for. Each estimate must be in a unique folder. What I am trying to
accomplish is gathering how many devices of each type I need from these
estimates.

"Roger Govier" wrote:

Hi Steve

Are there multiple sheets in each book with values, or just a single
sheet?
If there is a single sheet, is there any reason not to have them all in
the same workbook, as that would make the task much easier?

--
Regards

Roger Govier


"Steve" wrote in message
...
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.