Is it possible to automate data input from multiple workbooks

Hi! Okay so I'm alright with excel but I feel like there's got to be a way for me to make this more automated than going through individual workbooks every month.

Every day I'm sent a workbook with about 7 columns, most which can be ignored. The only data I need to pull from it is the min/max from column A, the max from column B, and to filter out column C before getting the min/max of column A.

At the end of each month I put together a review workbook showing the daily min/max from A and the max from B which then have their own formulas to compare trends throughout the month or if the numbers got too high or too low.

Is there a way I can have the information pulled automatically? It takes a few hours to go through at the end of each month and it's not the worst thing but it still takes time I could put towards other work.

Thanks!