It seems that a frequently required solution is to extract multiple instances of the same text pattern from one or more PDF files. The logic behind this is slightly different than the original setup which attempts to line up multiple data for the same pattern from multiple PDF files.
The new version, which can be downloaded from the original link above, adds a second table of results in the Output sheet which lists multiple instances of data matched within and across PDF files processed. This approach retains the benefit of the original consolidation approach while adding the support for multiple data instances within each file.
Another feature added is the ability to retain the text files generated for each PDF file to assists with pattern matching setup and for alternative use of the content. The new version has cell comments with detailed information on the logic.
Please post your feedback here so that we can continue to improve this free and open source solution for importing PDF data into Excel.
