Hi all,

I have a workbook1(sheet1) and I need to get data from a specific cell in workbook2 but workbook2 keeps changing name due to a daily update.

Name sample
report 01-01.xls
report 01-02.xls
report 01-03.xls
*
report 01-31.xls

All the way to the end of the month and then it goes in to the next month.

report 02-01.xls
report 02-02.xls
report 02-03.xls
*
report 02-28.xls

See attachment for more information.

Could somebody please help me.

Thank you
Julio