Hello,

I'm creating a master spreadsheet and I want it to pull live data from other spreadsheets depending on a variable.

I've a cell that has a variable date. I've files saved that have this variable attached to it in the name format: 'filename variable'.

I want to pull data, hopefully live, from workbooks based on this variable.

For example, I have files: generic 01212014, generic 01222014, generic 01232014.

The date is stored in the master workbook say in A1 that I can manipulate by entering a different date to pull data from a different workbook.

='[generic 01212014.xlsm]Database'!$L$3
='[generic 01222014.xlsm]Database'!$L$3
='[generic 01232014.xlsm]Database'!$L$3

There has to be away to make the bolded portions of the file name variable, right?