Multiple Sheets, One Pivot Table?

[anon]

So I have 1 excel with 8 sheets of data from 8 different years. They have the same column headings on each sheet. I would combine them into one sheet, but excel won't let me (too many rows).

Is there a way to do a pivot table with all the data? That is, create a pivot table from data on multiple sheets? Is there a way to combine all the data into one sheet? I've never used Access so I have no idea what I would do.

What I am trying to do is get a 'count' of a certain attribute for all the years, not just one year.

If not, then is there a way to make 8 pivot tables and then somehow consolidate that information into one pivot graph?

Thanks.

[DonkeyOte]

You might try a Multi Consolidation Pivot Table, however, they can prove limited in terms of their flexibility.

If as implied by your profile you're using XL2010 it might be you could use Power Pivot Add-In but I confess I have little knowledge of the application and it may not prove feasible (you might need each sheet to be a stand alone file).

Again, assuming XL2010, if you're saying you have too much data to consolidate into one single sheet (ie in excess of the 1m odd rows available) then I concur that you should be using a database as the repository in the first instance (not XL).