Extracting cell data from different workbooks

Hello,

Have a question. I currently have to compile reports for different customers, all of the same format, but each customer report data is on a different excel workbook (all reports are of the same format)

Am I able to create one workbook that is able to extract customer A report and reuse it to extract customer B report?

I.e. I create a summary workbook and extract/copy customer A's report number and report conclusion today and reuse the same summary workbook to do the same with customer B's report?