Extract word text from tables into excel

Hi,
I am struggling to find a solution that can help me in extracting data from various word documents, that contain tables into a meaningful summary in excel. I have looked over the various threads but have not come across one that I believe I can apply to my situation. VBA is fairly new to me so my apologies if I have missed a thread that I could use.

I have attached two files to give an example. The word file shows the typical format of the word documents, but in some cases there are more tables in some of the word documents, but I don’t next to extract those tables, only the data from the ones in the example.

The excel file shows ideally the file format that I am hoping I may be able to create in extracting the data so that I can then use this.

I really appreciate any help or advice that anyone may have time to comment on. Thank you very much in advance. Simon

Attachment 26929Attachment 26930

Although primarily aimed at extracting data from e-mail to Excel, the principles involved are similar to those described at https://www.gmayor.com/extract_data_from_email.htm. See the section on tables. If the documents are not all in the same format then there is no simple solution.

If you are just setting up this process it would make sense to use content controls in the Word document https://www.gmayor.com/insert_content_control_addin.htm to collect the data and that would make data extraction somewhat simpler https://www.gmayor.com/ExtractDataFromForms.htm