Cells in a certain folder

[That's Confidential]

If I want to work out the sum of a certain cell in a number of specific
sheets in a number of different files, is there any easy way than typing
"C\:My Documents\January.xls\!'Sheet1'A1+C\:My
Documents\February.xls\!'Sheet1'A1+"C\:My Documents\March.xls\!'Sheet1'A1.

Can you not just write something along the lines of:

=SUM(A1)ALL FILES "SHEET1" MY DOCUMENTS

Thanks

 

[Frank Kabel]

Hi
AFAIK there's no easier way if the worksheets are not opened