Can anyone tell me if I could create a worksheet that would be able to total a
value or values from multiple worksheets within a folder without knowing ahead
of time what the sheet names are? All workbooks would be identical within a
folder as they are all created from the same template. I would like to create
a totals worksheet that would take a value from a given sheet in each of these
workbooks and total it either dynamically or under some sort of program input.
For example a folder named September03 would hold 10 workbooks that included a
totals page for the workbook with particular cells that I would like to add
together in a unique workbook. Thanks,

Ray

You still need to be able to tell Excel the filenames. You could
probably do this by using the =INDIRECT() worksheet function to refer
to a manually updated cell, however this is not necessary.

All that is needed is the same named set of files contained in a
folder for each month (as you seem to have already). Excel does not
then need the path to the files and formulas will automatically refer
to the files in the same folder as the summary.

Always ensure that these files are set up,copied, and used *as a set*
in the same folder. If you change any links to refer to a file in
another folder the *different* path link will be retained in the file.


Regards
BrianB
==============================================



(RayVWbug) wrote in message ...
Can anyone tell me if I could create a worksheet that would be able to total a
value or values from multiple worksheets within a folder without knowing ahead
of time what the sheet names are? All workbooks would be identical within a
folder as they are all created from the same template. I would like to create
a totals worksheet that would take a value from a given sheet in each of these
workbooks and total it either dynamically or under some sort of program input.
For example a folder named September03 would hold 10 workbooks that included a
totals page for the workbook with particular cells that I would like to add
together in a unique workbook. Thanks,

Ray