I do individual price sheets for my customers that are linked from 1 to 3 source sheets. These source sheets are my vendors price lists in xls format. Of course these change quite frequently. If I add or delete lines from the vendor files, the customer pricers linked to those files will go out of whack. In other words a cell reference on a source sheet of say D 13 will shift to D 14 if I add a new row. The customer price sheet now references the wrong price. I'm sure this did not happen with Excel 97, or I had 97 set to be able to shift as needed without having to manually make changes. Problem is I can't remember/figure out how to do this. Can anyone help me set this up so that when I have to update my source files (vendor price lists) i.e. - add a new row for a new part (or delete) the linked cells in the customer pricers will move also. Hope this makes sense!!