Hello, I asked this question a few days ago and someone answered me and it
worked but by looking at what I needed it seems to be more extensive than
antisapated so I need assistance. Ok, I have a workbook with several
worksheets in it, each worksheet is set up the same. I want to have a main
worksheet that will draw totals from all my other worksheets. My worksheets
are named by date and the first being (Week Ending 2-26-6) and the last as of
now is (Week Ending 9-24-2006) someone gave me this for my function
(=sum(firstsheet:lastsheet!a1). It works if my sheets are named sheet1 and so
on but like stated above thay are not. I tried using =Sum(Week Ending
2-26-6:Week Ending 9-24-2006!L10,R10,Z10,AF10,AL10,AR10) but it just gives me
an error! I just want a total rome these cells from my starting worksheet to
my ending worksheet. Please help....

Thanks!
Chad