Is there a way to totalize data from multiple worksheets?

[MCV Celebration, FL]

I am trying to total data elements from weekly worksheets to a final work
sheet which will give me quarterly and semiannual totals.

 

[Anne Troy]

Provided you've got the totals in the same cells in each worksheet, you can
use this method:
http://www.officearticles.com/excel/sum_the_same_cell_in_multiple_microsoft_excel_worksheets.htm
************
Anne Troy
www.OfficeArticles.com