Macro to pull in data from excel file

Hi-

I would like to create a macro where I would be able to pull in excel data from an excel file that is in one of my drives. I am not sure where to begin. I have attached an example. Not sure if I need this in macro, but the path is listed below

T Drive-Reports-finalized details Archive-finalizeddetails071913 (every day a new report comes in with the date). I would like to be able to pull this file daily in my macro for most recent date.