Variable link in a reference

Hello everyone!

I hope someone here can help me... I want to make an overview file which gathers data from different excel files. Just one problem: due to historic reasons we create a new file each day, so if I want to create an overview of one year i have to enter 365 references, which is a bit much.

Cell A1 contains a formula like this:

='C:\production1\[Sam_PV1 16-06-15.xlsm]tab 1'!$G6

linking to the file where i want to get one number.

Cell A2 will be the same reference but with the date changed (it's always in the same location and same format):

='C:\production1\[Sam_PV1 16-06-16.xlsm]tab 1'!$G6

and so on... Is there a way I can make inserting the reference automatically? So that I don't have to enter it until 2017 and beyond?

I tried something with concatenate but then it's just text and no longer a reference...