Hot folder data sorting.

My goal is to create a hot folder that I am able to continuously drop data sheets into. Then have excel transfer a few specific cells ie.( totals, names )into a uniform row on a new table/sheet.

•all data sheets will be formatted the exact same and information will be in the same positions across all of them

•data sheets will be added daily

•each data sheet needs to create its own respective line representing information from only that sheet

•some of the cells needed are a result of total formulas in the data sheet

•no information besides the specific cells should reflect in the new table

(Photos in comments)

P1- example of the data sheets used with the cells circled that are wanted to be transferred.

P2- example of what it should somewhat look like when presented in the table/sheet