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