Let say that there is a workbook consists of 6 worksheets. Each worksheet
contains detailed monthly income and expenses, e.g., from Jan to June,
prepared by staff. The manager can only need to read the summary of each
month, compare the summaries, review trending, etc. on the "cover
worksheet". In case he needs to understand the details, he could go to
individual worksheets.

How this can be done? Any pointers are appreciated.

Many thanks,

You likely need to sum across worksheets:
http://www.officearticles.com/excel/...rk sheets.htm
And here's some other tips you might be able to use:
http://www.officearticles.com/excel/...soft_excel.htm
****************************
Hope it helps!
Anne Troy
www.OfficeArticles.com
****************************
"Doug Fox" wrote in message
...
Let say that there is a workbook consists of 6 worksheets. Each worksheet
contains detailed monthly income and expenses, e.g., from Jan to June,
prepared by staff. The manager can only need to read the summary of each
month, compare the summaries, review trending, etc. on the "cover
worksheet". In case he needs to understand the details, he could go to
individual worksheets.

How this can be done? Any pointers are appreciated.

Many thanks,