Avoiding reference error on Worksheets

[apolloman]

I have a emailing list workbook that I use with merge in Word. The complete mail list is on worksheet 1 (500 names/emails), and the following 10 worksheets are the first worksheet divided into groups of 50 each. I used references back to worksheet 1 for all the cells in the 10 workwsheets containing 50 names each, thinking that if I deleted or changed rows/cells in the complete list in worksheet 1 the subsequent sheets would adjust automaticlly. What I find is that when a row is deleted on worksheet 1, I get a reference error in the formulas on the sheet with 50. Is there a way to be able to manipulate the complete worksheet, and have the sheets that refer to it not have errors in the formulas? Thanks for your help. I tried absolute and relative addressing to solve the issue, but neither seemed to work. Thanks