Open The files on where you want to get you accumulative data from and the do
the following formula:

=sum([File Name]Sheet name!Cell Range+[File Name]Sheet name!Cell Range)

Granted this is the long way of getting what you need but it works rather
well!!

"Mathew" wrote:

Hi
I have 25 diffrent worksheets with diffrent file name. Now i want to get
all the sums in one worksheet.Please guide me