change embedded date automatically

is there a way to automatically increment the date by 1 for each successive row with this as the original formula:

 

=SUM(‘M:FY 2018 DepositsDeposit Detail[JUL 11, 2017.xl sm]Deposit Recon’!$E$6:$E$11)

 

I have 365 spreadsheets for each day of last 5 years. All are formatted the same. I need to consolidate info from specific cells into an annual spreaadsheet for each year

By: Garth M Malena

Leave a Reply

Your email address will not be published. Required fields are marked *