i need a excel macro to read from several pdf file kept under one folder and put in on a single excel output file

[Deardevil]

Hi
Greetings.
Can anyone help me. I have several invoice files in pdf format which is kept under one folder. These invoice files which are in pdf format contents are in two part
1. first part contains bill details like customer name, bill no , bill date , gst no , etc etc.
2. second part of the invoice file contains (in the same pdf file) multiple raws (item no, item name, hsn code , gst percentage , gst amt) .
Basically i need to open the pdf invoice files (kept under one folder one by one) and copy data from those invoices and paste them to a single output excel file . The content of the output exccel file to have bill no , customer name , invoice date , item no , item name , hsn code, gst amt etc....
If anyone could help me to write a macro to do the task will be very helpful to me.
thanks

 

[ExcelToDAX]

I would recommend Power Query instead of VBA/Macros.