Multiple Sheets, One Pivot Table?

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.