terminology
workbook = an excel file with the extension .xls
worksheet=a tab within a workbook

If you mean that you want to total one cell in all worksheets within a
workbook
=sum(sheet2:sheet10!a1) formula in sheet1


--
Don Guillett
SalesAid Software

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