Work Sheet summary

[Stevealexa]

I have a workbook that collects weekly data from user input on a daily basis.

I would like to summarise the weekly totals on a single sheet.

i have a master template that is copied and re-named each wek to we18102002 etc.

Is this possible please

 

[Richie(UK)]

Hi Steve,

Could you give us a little more detail?

* Are all the weekly workbooks saved in the same directory?

* What format do the weekly workbooks take? Eg. tell us how many columns are used and what the headings are, ideally give us a few examples of the data being used.

 

[Stevealexa]

Hi Ritchie

Sorry I think I misled you.
There is one workbook
All the weekly sheets are contained in that work book.
I need to summarise things like
total sales (for week) total expenses etc etc
which obviously are in the same place on each different sheet.
Steve