Sounds like we are about 12 hours apart.
What I mean by exporting is that you set up a template file in excel and a query in Access. You copy the data from Access into your template file, refresh the report section of the spreadsheet and it updates itself based on the new data.
I have attached a bare bones example. There are 2 tabs--data which would hold the raw data from an Access query. The pivot tab looks at the data tab and is the final report. You would the pivot tab to look exactly like you want and then whenever you needed to generate a new report, you run your Access query, copy the data to the data tab of the spreadsheet and refresh the pivot.
What I mean by exporting is that you set up a template file in excel and a query in Access. You copy the data from Access into your template file, refresh the report section of the spreadsheet and it updates itself based on the new data.
I have attached a bare bones example. There are 2 tabs--data which would hold the raw data from an Access query. The pivot tab looks at the data tab and is the final report. You would the pivot tab to look exactly like you want and then whenever you needed to generate a new report, you run your Access query, copy the data to the data tab of the spreadsheet and refresh the pivot.