My personal opinion is that "lazy" engineers are the best engineers.
They tend to look for ways to make work easier for themselves and others!
I think you need to look at the macro programming available in Autocad.
You may need to find a dicussion forum specifically for that.
Excel can launch the Autocad application and open the file, but the
methodology, syntax and techniques for getting to the data  in the tables
is specific to Autocad.
Once you determine how THAT is done, you can use the add-ins for Excel
to get to the data.
I think it's VERY possible to automate this task.
But, like I said, you're going to have to look to AutoCAD to find
the techniques to get at it.
Once you've got that figured out, you can extract the data from all the files
and even set up a scheduled task to refresh the data from any files  that have
been modified since the last time a refresh was done.