Cosolidate worksheets with non-tabular data with Power Query

[wilster98]

I sometimes receive forms in Excel from various people where The data is scattered about in each sheet (see below)., and there is a separate sheet for each part number. Now I need need to pull Purchase Order Number and the Part Number from each sheet and put it into 2 columns. The info I need is always A5 and K4. I tried this in Power Query, but I can only see one worksheet in the Query Editor. Can Power Query do what I need?

Thanks in Advance
Willy

 

[GraH]

Hi, it can be done via PQ. Please have a view of this tutorial.