Extracting Specific Fields from multiple PDFs with VBA (Excel 2019)

[chickyguy]

Hi All,

I been given a folder with a list of PDFs and I need to extract certain fields out of it to an excel sheet.
However, we are only capable of using Excel 2019, so Power Query was out of the window.

I'm currently attempting VBA to solve this problem. However, I'm not well-versed at all so I don't even know if a solution is possible.
Currently I'm able to read the PDFs by converting it to a Word document as per a thread on this forum previously, and am in the process of attempting to extract only specific fields from it.

Due to sensitivity of the PDFs, I'm unable to upload a sample.
However, I have done up a sample structure of the PDFs:

Between Information Uno and Cinco, there are 3 other tables that can be ignored.

My needed output is this:

The caveat is that the fields names from PDFs might vary across each other, so FieldA might be AField in another document... but the position of the data within the table is the same.

Any advice is welcome and thoroughly appreciated - even if it's just advice saying its not viable.

 

[chickyguy]

Apologies for the double comment, but I made a mistake. Field names may differ, and so do positions.

there might be a FieldC and FieldCA, pushing down FieldD further in the table.