Hello all, I am relativly new to the the VBA scene and am working on a project to extract data from a certain file in a folder and a certain sheet in that file but a new workbook is made every week and a different sheet is utilized everyday in that workbook.

For you all to get a better understanding of what I am working with, a supervisor makes a schedule of the the operators and what part and process they will be taking care of that day. A new workbook template with the weekly schedule is created the beginning of the week and the file name ends with the date of the week ending i.e .....7-12-14.xls or ......7-19-14xls. The supervisor updates the workbook for that week every morning for there are sheets in that workbook for everyday of the week. So he/she creates a workbook for the week and then updates the days of the week in that sheet, once the week is over a new sheet is created. I want to create a macro that finds the weeks ending date in that specific folder (file location never changes just file name) and be able to copy the data from the current day's sheet name (so if I run the program on a tuesday it will return the data from the tuesday sheet or on a Friday the data from the Friday sheet)

I was thinking of trying to use a couple list boxes in another sheet to allow the user to input the week ending date to find the file in the folder and the day of the week to isolate the specific sheet. But i am not sure how to get this to interact with the code

Any Suggestions on a direction to go? And good sources I can check out? or has anyove had any experienced with this kind of thing and already has code created that I can check out and manipulate for my app??? :)