Create a Excel document using VBA or VB using specific MS ACCESS Data tables and fields

Create a Excel document using VBA or VB using specific MS ACCESS Data tables and fields to create a variety of excel worksheets with specified names on the sheets and  data placed in specified location on certain sheets.

 The data is in several tables in the database  and the table names are know and the  fields are know,  with this information known  I then know where I want to place the information in the excel document what worksheet  by name and the cells that it can be pasted to.  I have been reviewing the object model for vba and access and excel and am unsure  how to accomplish this.  I have over 150 database where I need to pull several small pieces of data from.  I will provide samples below.

The example is as follows: ultimatly saved as an excel firstphase.xls

( there will be several worksheets but the first will be called - worksheet name: buildings

The cells that the various data will be places is as follows:

from ms access  database named:  probuild
the table that data is to be pulled form is tblbuildingcodes
and the first field fromt he table that I need all  records from buildingname this information in asc order  

i.e. probuild.tblbuildingcodes.buildingname
will be placed in cell starting at A6 ( down the page)


the next field from the table will be buildingcode
i.e. probuild.tblbuildingcodes.buildingcode
and this will be placed in the excel worksheet starting at cell d6

I need to label with fix text  cells a1, a2,a3,a4, a6, and the same for d1-5.
i.e. cell d1 builing
d2 western
d3 sections
fieldname (from tblbuildingcode) ( if this can be done other wise I will jsut hard code it np.)

then save the excell sheet to the same folder where the database is located and called firstphase.xls

I hope that there is someone out there that can help me with this issue, I have been going over the internet looking for help with creating excel docs using vba in ms access but have not found enough defined to aid in the process I am trying to work out otherwise it will take forwaver to copy and paste the data from 150 or more different databases.

Thank you very much!