Importing PDFs With Structured & Misc Data To Multiple Table (500+ files)

Multiple queries was the key (I think), thank you. Having never done it before, I was stuck on going all-in-one so to speak, but I've now got 4 separate queries going that appear to pull the data into 4 separate tabs/tables in excel exactly as I want (3 for 4).

The last one I am trying to transform I have like below, rows 1, 4, and 6 have what I want to be the column headers and rows 2-3, 5, and 7 have the corresponding data that would go in those columns. Still working on that transform and the only issue I see is it appears that when importing, because the text in the "QUALITY CONTROL ACTIONS IMPLEMENTED" section was more than one row of text in the PDF, it didn't just run long in one row but put the wrapped portion on line 2 into another row/cell (hence 2 and 3 instead of just 2). Will need to figure out how to dynamically deal with that with all 3 sections since the notes vary from day to day.

Unfortunately can't share the actual files since they are "technically" sensitive (functionally, not at all) and currently don't have the old template they were using to create these in the first place to make a dummy PDF. Appreciate the input