Organize and Sum Data

[showboat]

Hello,

I receive up to 1500 pdf documents that look like the attached document. Normally I go through by hand and add up certain information under the Fabrication Materials list. I had an idea to crop the Fab Materials list only and export it to excel.

The information that adobe spit out into excel is the data on Tab Table 1. Column A means nothing, Column B is footage or quantity, Column C is pipe size (if it says 6"x1", the pipe size is 6").

I'm looking for a way to automatically sum the information in excel on tabs Line # and Summary.

The line number in the spreadsheet example is 6"-CW25406-E-SS01-1. Adobe spits this out at the bottom of the Fab Mat list in random columns A-D. The headers such as PIPE, FITTINGS, VALVES also get spit out in random columns A-D.

The last number in the line number is the insulation thickness, so the above line number, every pipe size has 1" insulation.

Please find the attached spreadsheet and let me know what questions you have or if this is even possible. Thanks for the help!!