I posted this a while ago but got no response but I'd like to try again.

I have a workbook that has a large (long) data table on one sheet. The table
is referenced as a dynamic range. I access this data via DSUM and some other
database functions. Some time in the next month we will reach the
maximum number of rows filled on the data sheet. We use the history on
this datasheet in our reports so we don't want to consolidate it. So the
question is, is there any way to have the dynamic range span multiple
worksheets within a workbook? Or, is there a way to have the DSUM function
e.g. =DSUM(inventory,"qty",O20:R21), access and operate on more than one
range, like a range continuing on a different sheet?
Thanks in advance,
RDW