ASAP HELP!! Data from multiple sheets

[Taffalaffa]

I need help. I am esentially gathering information from 65 different time cards and compiling the different data into a recap sheet. How can I create a forumla that will automatically take the next sheets data? On each individual sheet the data is in the same boxes (hours are always in J28, Dollars in J29, Labor Equipment in J30). I am trying to use:
=+'1'!$J$28 but I am not able to copy this forumla and have it automatically make it =+'2'!$J$29. Please help me! I have 65 time cards I need to get info from and four fields per time sheet and I don;t want to enter each formula manually. Thanks!

 

[Taffalaffa]

Hi- I ended up having to fly to Montana for an immediate bid on a project and didn't have time to figure out the formula. I tried it but couldn't get it to work but I was in a rush. I fly back tonight and will spend some time on it tomorrow because if it does work it will save me a TON of time in the future! A bit confused about what is supposed to go in that first set of """" though...

 

[p45cal]

Did you manage to make it work?