That's not a lot of information to go on, but....in general, you could start
with:

1)Select the cell where the data pull will begin to store the Access data
2)DataImport External DataNew database Query
3)Select the MS Access data source
4)Select the table(s) you need to use and progress through the MS Query
screens.
5)At the end, you can either select to edit the query or just send the data
back to Excel.

6)Repeat for each sheet that is to receive the MS Access data.

Thereafter, you only need to select a cell in the data range and DataRefresh

Does that help?

--
Regards,
Ron