While this might work, it is almost what I am having to do now to
get the data  I need. The problem is that this process takes a long
time for each drawing, even getting faster only makes it slightly
shorter duration.

Today I have 653 drawings I have to do this to, and that will take
me a good portion of my day. I am looking for a way to automate this
so that the computer can do it and leave me out of it. Then once the
excel sheet is built I can run other macros/vba programs to
edit/modify/analyze the data. The excel macros are already built....
I'm a lazy engineer, I hate doing stuff like this, so I find ways to
not have to.