I'm thinking there are 3 ways you could go with this, depending on your
flexibility:

1)Pull all relevent data from Access in to a worksheet., then create a Pivot
Table to display the data you want or use lookup/index/match functions to
calculate the specific data.

2)For each tab, create data driven Pivot Table that will pull only specific
data from Access.

3)Create a VBA solution.

Mull those over.
Post back if you need more help...There are many experts on each of those
areas avaialble on this forum.

--
Regards,
Ron