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

Example_excel file.xlsxExample_Word Document.docx