data from one sheet to several in sequential order!

I am having a problem transferring data from one sheet to several in sequential order!

I am building an overtime equalization form for 50 employees, sheet 1 is week 1, sheet 2 is week 2 and so on for each week of the year.. Column A is the employees names, column B is the hours from the last week’s total, column C is the overtime hours from the last week, column D is total across columns B and C on each sheet respectively. Columns E – K represent Monday through Friday.

I have no problem getting the data to add on sheet 1 and 2, for example:

I have the data coming from columns E – K sheet 1 to column C on sheet 2! I used the formula =Sum(Sheet1!E1,F1,G1,H1,K1), but on sheet 3 I can’t get the data to column C by using =Sum(Sheet2E1,F1,G1,H1,K1) and so forth.

Same for transferring the data from Column B sheet 2to column B sheet 3. I can get from 1 to 2 but not to sheet 3, 4 ,5 and so forth!

Is there an easy way? I have searched for days and still can’t figure how to do it.

Am I way off base?

don't miss the exclamation point

OOPs! I checked and I only missed it in my post!

I try again as soon as I get back from Lunch!
Thanks

I must be tupid!

When I go to sheet 3 and put =Sum(Sheet2!E1:K1) a pop up comes up and ask me to update the values for sheet 2. When I click OK it goes to my folder work book is saved in! If I choose the wook sheet it shows all the pages, I click on page 2 and it changes the value I just entered in page 3 to "=SUM([Sheet2]Sheet1!E1:K1)"


What gives

Man I must be STUPID!

I figured it out! When I made my sheets, 52 in all, I coppied from page 1! So the name was not sheet 2 it was sheet1(2). When I figured this out and changed the sheet names to Week 1 through Week 52, it worked like a charm!

Great forum Thanks!