Ranges spanning worksheets
 

I have a workbook that has a large (long) data table on one sheet. The table
is referenced by a dynamic range. I access this data via DSUM and some other
database functions. Some time in the next month we will have more than the
maximum number of rows filled on the data sheet and we use the history on
this datasheet in our reports. 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?
Thanks
RDW