I have an annual income statement that I would like to copy data to a new file every year. Every year the new file name is for the previous year(2015).
This file was built in 2015 with the data coming from the 2014 file name.
2014 2013

$58,379 $55,130
11 23
58,390 55,153

12,601 12,525
1,676 3,719
For the new file(2015) I want to copy data from column 1(2014) to column 2(2013) in the new file. The problem I have is every year the file name will change by one number. This formula works for this year but won't copy right for the next year, =[2014.xlsx]Income!$E11
Is there some way to get the file name from the date at the top of my column? This way I would just have to change the date in one spot.