Some links that can help with designing VBA to handle AutoCAD are below:

Iterating through layer collections

Delete all objects in a layer

How to copy all objects from one drawing to another in autocad through VBA