Hi:

I have a spreadsheet that tracks payroll for the entire year. One worksheet per payday (so 26 worksheets). They are all set up alike.

I made a summary sheet to gauge totals throughout the year. I am referencing each column on the summary sheet as:
=Sum('Sheet1:Sheet26'!A10) and copying that down the column. This appears to work fine.

My question: How do I enter a new employee and keep everyone's info on the proper line?

I tried using absolute values that that doesn't seem to work.

Any thoughts?

Thanks,
Deb