Hi,
that works great so far, thanks a lot! 
But I have one further question: I now have 20 worksheets, every sheet storing the "sum.total" value in column D - Cell [1]. I would now like to copy (or link to) all those 20 values to one column of a new workbook or worksheet (called e.g. "Summary") for further calculations.
[Sheet1] Col(D)[1] ---> [Summary] Col(A)[1]
[Sheet2] Col(D)[1] ---> [Summary] Col(A)[2]
[Sheet3] Col(D)[1] ---> [Summary] Col(A)[3]
...
[Sheet20] Col(D)[1] ---> [Summary] Col(A)[20]
Is this possible?