This sample database from Nifty Access demonstrates how you can take different sets of records from an MS Access table and show each different set on a separate spreadsheet page in Excel.
There are full instructions on the Free Version in my Blog:-
Go there to see how to get the Free Version up and running. If you have any problems post your questions in this thread!
One of my customers had a minor problem with the original code, I fixed it, and have uploaded an update. I left the original zip file suffixed with (1a) and added a new zip file suffix with (1b)