Import Various Tables with Different Formats from PDF into Excel and arranged.

I am trying to import multiple PDF tables into Excel but the tables appear on different pages with 3 different formats of the table. A solution on how to import PDF tables with the same format has been provided in the link below and it worked great for me for the folders that have the same format.

https://www.excelforum.com/excel-pro...ml#post5858137

This time I plan to import from multiple PDF tables with various formats and the values I need to extract are shown in the attached pdf in red. How can I modify the solution shown in the link above to be able to solve this problem?

The results that I need are shown in the excel file called output2.xlsx. The results in blue are from the first table format, the results in yellow are from the second table format and the results in green are from the third table format.

Overall, I plan to read through a folder that has about 700 pdf files with these tables but these tables do not appear on specific pages.

**Please also note that the PDF may have other tables that are not relevant. I want the Query to be able to skip all those irrelevant tables and pick the table formats that I specified

Thanks in advance