Todd,

Think more "out of the box". Create just 1 query for all CM. Use a
parameter where you can filter on the data for each CM(or even select
all CM). Let your *boss* select the CM and then do a refresh (you could
write a macro for this). No need to put it all there at once!
For the summary you can create one additional summary query, or use a
pivottable(works very well) based on the excel data of your query.

Some hinst & tips:

Create Access queries that do "most of the work" in Access to easy
query creation in Excel, but let excel do most of the filtering (on
e.g. CM ).
Don't use VBA in those queries, else they won't work in Excel.

Hope this helps,

DM Unseen