Vba code to extract specific data from pdf file and insert it in an excel sheet

Hi Everyone ,

I receive a pdf file received that needs to be breakdown for specific case box use to extract tax values.

Note as per pdf sample file ,Box 40 tax base code varies depending on box 27 commodity code

Attached sample of expected results .

So far what I have tried through acrobat reader and power query but did not give the expected results .

Actually ,doing it manually which is very tedious

But so far using also a converter but still unsuccessful to extract pdf table.

Can anyone assist throught a vba code to extract the requested box data in excel format.

Thanks John working as requested but my only trouble is when converting pdf to excel it seems the cells moves. which creates blank columns.

Is there a way to troubleshoot this, I suspect that conversion are not same despite using original pdf file 2nd different file attached with the test done

I used able2extract for the conversion pdf to excel.

See attached the results getting some columns empty but tax compilation are ok , but just one tax code i missed from another pdf file converted , need to be adjusted

Amount Payable Tax 49, i added .

I will try and advise but am trying to find a more stable converter pdf to excel as it seems to be inconsistent during the conversion despite having original pdf .