Hi All,

I'm trying to do the following:

1) From a folder containing invoices in PDF form, extracting the data into an excel sheet
2) Each file in the folder has a standard table part of the invoice(same amount of columns + same headers, with different rows depending on order)
3)What I have been able to do is to use the get data method>from file>folder>click the relevant folder>transform data>combine file arrows next to content> From there I would choose a table and Im not able to choose a data range across many pages. As naturally some invoices will be shorter(1 page) vs others will be longer Eg: 10 pages).
4) Did see a way to consolidate multiple sheets but this method seems to work only for one pdf vs multiple
5) can someone share how to use power query to consolidate data across multiple pdfs(with each pdf having multiple sheets each) Will maintain same standardizationa cross each pdf and sheet
6) Happy to work with a VBA code too. thank you so much

Rajah