Single Pivot Table off Multiple Sources?

Is it possible to create a single pivot table that points to multiple sources? I ask because I am faced with the probability of maxing out my rows on my pivot table, since Excel worksheets cap out at 65,536 rows.

Meaning, if I have data for 2005 that is 50,000 rows long, and data for 2006 tat is 55,000 rows long, can I consolidate them into one pivot table, assuming they have the exact same columns? I want to show trending across years as much as possible.

I looked at Multiple Consolidation Ranges as a potential solution, but it looks rather limiting.

Thanks.

Chuck