All -

I have a workbook with 5 sheets. All sheets a different number of rows
and all have at least 40K rows.  I have two columns for which I'm
creating a pivot table. I've been able to do that for one sheet.

What I really would like to do is create one pivot table encompassing
the same columns from the 5 individual sheets. If I could really have
what I want, I'd be able to filter the pivot table so that the data
for each sheet shows individually as as well.

I know that in 2007 I could simply move all the data to one sheet; the
issue is that the person I'm working with has 2003 which has the 65K
row limit.

Any tips, links etc...?

Thanks in advance-
Danielle