Referencing Multiple External Workbooks

[Gravoir]

Hi all,

i have a large spreadsheet that I am looking to populate from multiple external workbooks. I am using the following formula which works perfectly:

=SUM('/Volumes/Seagate Drive/Thunder Cloud/Dropbox/[HD_280416.xlsx]Daily Intake'!$D$8)

My problem is that this works for one external file. I want to drag this formula across multiple cells so the part of the formula in bold automatically changes to the next day. So the above would be in cell A1 and when I drag it to A2 I get the following:

=SUM('/Volumes/Seagate Drive/Thunder Cloud/Dropbox/[HD_290416.xlsx]Daily Intake'!$D$8)

I have hundreds of files structured in the same way that have the same file names with exception to the date part which is when they were created/the day of the year the information within them is applicable to.

 

[Roderick_E]

We need some place to store the starting date but then you could do something like:

=SUM(indirect"'/Volumes/Seagate Drive/Thunder Cloud/Dropbox/[HD_" & column()+text(startdate, "ddmmyy") &".xlsx]Daily Intake'!$D$8"))

startdate part could simple be a cell where you are keeping the start date, such as 270416

needs to be a static cell $A$#