what i want to do is be able to add a cell like D3 on 53 different worksheets
and place the sum on another workssheet in the same workbook. easiest way to
explain is i need a weekly report and want to toal the same cell to a year
end report in the same workbook.