Collect info from multiple workbooks

[Jwoody]

Hi, I’ve adopted a, very old school, way of storing invoices and would like to combine some information from them all. As it stands each invoice is it’s own individual saved .xls file. What I want to do is create a master log. So I want to get invoice number(for example cell F3), date (for example cell F8), customer name (for example cell B13) and customer reference number (for example cell D3) from each workbook and get that info into one table/sheet? Please tell me this is possible? I’ve tried with powerquery but with how the info is scattered the results don’t make sense?