Linking many files dynamically?

[MOB]

A folder contains identically structured spreadsheets, and I want to sum the total of cell A1 of tab "summary" for every file in that folder - but if new files are added to that folder it includes them, and if files are deleted, it doesn't fail.

Obviously I could say =(spreadsheet 1 A1)+(spreadsheet 2 A1) and so on, but would rather not.

Is this possible?

TIA

 

[MOB]

Bump anyone?

 

[Grizlore]

Sounds like you would need to use VBA.

unfortuantely I know in theroy what it would need to do, but I am not savvy enough in VBA to write the code.

You would need some VBA code to loop round and open the files which are present in the folder (and only those which meet the name criteria you have set) then they would need to open them, grab the number and do the calculation.

btw - nice day in Northants today