excel project - macro tasks need amending 9

On the attached spreadsheet contains a macro which does various things.  On the last worksheet I need the macro updated please so that the data maintance task looks at a range of files to update.  This range need to be the same function as that displayed in the macro of the first worksheet please.

Thanks.
summary-macro-test--needs-range-.xls