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.

A couple of more facts about the layout might be useful. Are all the folders
(directories to old timers like me<g) containing estimates under the same
master folder? That is, if we go to the master folder, can we restrict are
search to just folders located within it? If so, are there any other folders
inside the master folder that do not contain estimates? If so, are the
folders with estimates named in some similar way so that they can easily be
distinguished from the non-estimate folders? What I am trying to get at is a
method to identify where the workbooks are without having to search the
entire hard disk(s) looking for them. In the end, I am not sure I will be
able to answer your question, but those with the knowledge to do so should
find this information useful.

Rick