Open most recent file and V-lookup to extract data

Hello,

Please be patient with my verbiage, as I am new to VBA coding, I appreciate your help GREATLY! I've done the best research I can do on these threads, but I can't seem find one specific to my quest.

Goal: To write VBA code that opens the most recent file created in a specific folder, open it, and extract data to the current workbook.

Example:

Report 1: "Customer 08-13-2014"
Report 2: "Customer 08-20-2014"

Both Reports are in the same folder. I work in an accounts receivable and these reports are weekly agings that contain invoices, due dates, amount dues, etc... Each week when I create the reports, I add specific notes to the report. So, with each new week (another report), I manually v-lookup(report 2) to the prior weeks report (report 1) and copy them to the new report (report 2)

Data example simplified: In Report 2 Column "x", I v-lookup column "a" in table array report 2; columns "a:f"

Since I am newbie, if I missed any pertinent information, will you please let me know? In my department our reports reference other reports quite often, so we are constantly using vlookup against other reports to retrieve information. And each week those reports are updated with a new file and date, so if I can figure out this VBA coding, it will be a LIFE SAVER! I can't be thankful enough to those who decide to take on this challenge/task with me.

Again, thank you, and please me know what other information would be helpful for this code.