Also look at Data=Consolidate

--
Regards,
Tom Ogilvy


wrote in message
ups.com...
Thanks, but this looks like it is for several sheets WITHIN a workbook.
I am talking about the same named sheet in different workbooks.

Don Guillett wrote:
=sum(firstsheet:lastsheet!c3)
To do the same for "selected" would require a macro

Sub sumselectedsheets()
On Error Resume Next
For Each sh In Windows(1).SelectedSheets
ms = ms + sh.Range("c3")
Next
MsgBox ms
End Sub

--
Don Guillett
SalesAid Software

wrote in message
ups.com...
I have a template that contains cells for number of hours worked in
several rows and columns. I have many copies of this workbook, one for
each employee. I would like to be able to add the cell C3 (for example)
across all of the workbooks that I select...basically merging them all.
Is there an easy way to do this. I spent an hour searching this forum
using different keywords and haven't found a solution yet. Thanks in
advance for any help you can give.

Jeff Wilson