I want to streamline a repetitive drafting workflow by building a small suite of Python- and VBA-driven utilities that talk directly to our AutoCAD drawings. My first and most urgent need is an extractor that can open a folder full of DWG files, locate every tag ID drawn inside a rectangle, and return the raw data and accompanying metadata—plus the exact X,Y coordinates of every tag—into a clean Excel workbook. Once the core extractor is working, I also need the same script (or a companion VBA macro) to carry out a few housekeeping tasks automatically: • run validation passes that flag duplicates, impossible formats, or tags that are missing coordinates, • assign an unambiguous primary key so nothing clashes when we merge files later, • separate DWG files from any other formats that may be sitting in the same directories, and • publish a quick-view PDF version of each processed drawing for spot checks. The Excel sheet you deliver should be ready for our downstream “tag register” quality-check routine, so clarity in column names and consistency in data types are important. I will supply sample DWGs and our existing naming conventions; you return fully commented source code, the compiled add-in or script, and a brief README that explains how to point the tool at a new project folder. No external paid libraries, please—standard Python libraries, open-source AutoCAD APIs, or plain VBA are fine. If you have done something similar, let me know what APIs or modules you prefer to call and how you handle coordinate systems inside DWG. I’m ready to start as soon as I see a workable approach.