Thanks for the advice, yes i did mean workbooks and figured i'd have to do
your summary idea Tom, thanks

"Tom Ogilvy" wrote:

Note that this method does not work for workbooks. If by workbooks, you
meant worksheets, then your on your way. If you really meant workbooks as
you stated, then you might adapt to this method by inserting a new sheet in
the summary workbook to summarize the individual workbooks - then have a
final sheet to summarize year to date.

--
Regards,
Tom Ogilvy


"Anne Troy" wrote in message
...
Try the method described he


http://www.officearticles.com/excel/...rk sheets.htm

*******************
~Anne Troy

www.OfficeArticles.com


"blummincars" wrote in message
...
I am creating a summary worksheet and i was wondering if it is possible
to
add values together from different workbooks and then have it
automatically
update when i create a new workbook, the workbooks being named week 16,
week
17 and so on in number order. So that when i create week 18, the figures
get
included into the summary