Data is imported to a sheet labeled "summary" from a sheet labeled "detail".
(Particular cells will sum all of the rows containing dates that fall between
a particular week - this works fine.) My problem is that whenever I update
the "detail" sheet, the cell references that point to a particular data range
always change themselves, on both the "detail" and "summary" sheets.

For instance, as soon as I update the values on my "detail" sheet, (all
values are a data query imported from a Peach Tree Excel Export file - this
works fine), a cell refering to "$L$5:$L$1000" will change to "$L:$4:$L$992"
for no reason (it seems). This can result in a VALUE error.

I want to stop this from happening, can I do this, or is there a better way
to do one of the things I mentioned above? (I need the data to flow in a
chain because it gets manipulated between the PeachTree Excel export file and
the "summary" sheet. This is what the "detail" sheet is for: give each row an
additional value of "reimbursable" or "non-reimbursable" from a drop down
list.)

Thank you for your time, Marc.