Can I ask why you are duplicating the Excel format in Access, rather than taking advantage of Access's capabililties to extract the data from one table?
Also it would be easier to do this from Access by importing the Worksheet using the TransferSpreadsheet method.