Sum items based off multiple variables

I can receive anywhere from 10 to 5,000 pdf drawings (see attached example). I had an idea of cropping the pdf to show only the Fabrication Materials section and then export it to excel. Once in excel, I am wondering if there is a way to go through the content and sum up different items. I have to do this by hand and it is extremely time consuming. I would like the information sorted 2 ways. The first way would be by Line Number: So it would say Area = M, Service = SH, Count = 752, Insulation = 2, and then list all of the pipe sizes, feet, elbows 90&45, fittings, flanges, and valves associated with those 4 conditions. The second way of sorting would be to list the total amount of footage, elbows, fittings, flanges, and valves for each pipe size in the batch of drawings. I'm not sure this is possible based on the number of variables and the list of Fabrication Materials can be anything but any help would be greatly appreciated. The Fabrication Materials that stay the same are the titles in bold, anything else below that can change. Some drawings will not have 1 or more titles, so a drawing could only have PIPE with 1 item and that's it.

Tab Table 1 is the information exported from pdf to excel. The highlighted in yellow is the "Line Number". The last number in the line number is the "Insulation Thickness". I made it RED on the Line # tab. I did not manually add up all of the values for the Line# tab and Summary tab. I just made headers and showed examples of what I would like it to look like. Also, Table 1 only has 10 pdfs. Sometimes there are thousands. I do not care about the items on Table 1 under the headers "Fasteners" and "Olets". There will be random descriptions under column D that I have deleted out. For the elbows, there will be random information in the description column D after the words Elbow, 90 or 45. On Table 1, Column A is irrelevant. Column B is the Quantity and Column C is the Pipe Size. Sometimes the pipe size will say for example (6"x1"). I would like the information to show up on the Line # and Summary as a 6" pipe size.

PCI, any luck with this?

Any luck with this?

PCI,

Yeah I figured it would be a tough task to accomplish and Im not even sure if it's possible. The thing that's hard is knowing how ADOBE exports the information to excel.

I would like the information in Table 1 sorted by Line # and by Pipe and Insulation Size.

The line number is not always in column A. I don't know why but sometimes ADOBE puts the line number in column D as well.

The line number will always start as (number)"- so that might be a way to search for the line number. The last number in the line number is the Insulation thickness.

The keywords in column D are the bold headings such as PIPE, FITTINGS, VALVES, FLANGES.

On Tab (Line #): From rows 1-11 is the information for line item 6"-CW2406-E-SS01-1. The insulation thickness is 1". Under the header PIPE the sizes are 2" - 2 feet, 3" - 1 foot, 6" - 19.75 feet. Then under the FITTINGS header you have quantity of 2 for 1" pipe size. In column D under header FITTINGS, it will say 90 or 45 in the description to account for those if there are any. OLETS and FASTENERS do not matter. Then under header VALVES, you have quantity of 1 for 1" pipe.

On Summary tab, the line number does not matter. I am simply interested in the total summary based on pipe and insulation size. For example, So throughout all the information on Table 1, there is quantity 100 feet of 1" pipe by 1" insulation with 10 90s, 12 Fittings, 13 Valves, 55 Flanges, 10 45s

Was that enough information? Do you need anything else?

PCI,

I'm not sure what you mean by that. See attached excel sheet with only 1 line #. I want the information on the Line # tab and the Summary to automatically appear based off of the information on Table 1.

Please let me know if this is still unclear.

Does that make more sense or do you still need more information?

On tab Table 1:
Column A means nothing
Column B is quantities. Under the Pipe headers, they are linear feet. Under the other headers, they are quantities.
Column C is the Pipe Size. If it reads 6"x1", the first number is the pipe size.

Let me know if you need anything else.