Populate Excel Worksheets with data from access

[bdavis6290]

I have a access database with tbl's, and qry's etc., and a Excel spreadsheet with 30 or so worksheets. ex. (02), (04), (06) and so on. Each worksheet represents a specialty. What I'm trying to do is have access open the spread sheet grab data from a tbl in access, match the cmsspecialtycode with the matching worksheet in excel and make a copy of that tab with each person within that group of specialties and move them before worksheet (02). After that group of specialties is complete I need to save the spreadsheet with title in range (7, O) with in that specialty. Ex: (06) = test project (06) then select the all new work sheets before (02) and save them in pdf format with the same name as the spreadsheet. Before moving to the next groups of specialties delete all worksheets before (02) and move to the next group. Any help would be great