Consolidating Tabs Into One Master Sheet

I was given excel tabs with data for deposit accounts from now to fiscal year 2004. Each tab contains only one fiscal year, and this is extremely inconvenient. What I would like to do is consolidate all the fiscal years (each with four different deposit accounts) into one single entity. What is the best approach?

My initial idea was to use powerpivot or Access in some way.