Good day,

I have a folder (A) with multiple workbooks. Workbook names are named by current day of month. All workbooks contain 5 worksheets. New workbooks are added daily. Please help me with a code that will AUTO sum, lets say cell C5, of worksheets named "middle", of all the workbooks. Also, the macro in the master workbook needs to auto run every time a new workbook is added to the folder, as no-one will open this master workbook. I have another workbook that will by means of a formula update as the cell in the master workbook updates. Thanks a lot...