Hi,

I am working on large chunks of data spread across multiple spreadsheets.
I want to be able to run macros that treat data across these sheets as
contiguous.
eg. the avg() on column A should take into consideration all the values in
column A in all the spreadsheets.

Is this possible ?

Thanks in advance for your help!