Sheet List

Hi All,

Just wondering what other people have done. The problem is we have a list
of sheets on the index sheet and the same list of sheets on the specs
(created in Microsoft word). My boss would like these two lists that are
created separate to be linked, so if we change the index sheet the change
will reflect on the specs. My first thought was to have the list created
in Access from the index sheet then have a table imported into Word.
Anytime the list changes we could update the database, then the specs could
be updated from the list. We have an attribute block that consists of the
sheet number, title, date, and revision. I have created a program in
Autocad VBA that scans the index sheet for these blocks and updates the
database to make sure the database matches. I am having trouble on the Word
side of it, I can import the table into Word but the formatting will reset
each time I update it. It is turning into a bigger project than I
anticipated, so I started wondering if there was something easier. I
looked into the Sheet Set manager where you can have a table created from
that, but our index sheet has consultant drawings listed also which aren't
in the Sheet Set Manger and I dont know if i can export the table to Word.
So I was just wondering if the database route is the best solution or have
people done this a different way.

Thanks
Brian