Pulling data from yyyyMMMMdd.xls
 

My file names are as follows yyyymmmmdd.xls - 2005August21.xls,2005August22.xls

Presently the data (E5:E33) then (H5:H49) is copied then pasted
(Value+Transposed) into '2005 Daily Production.xls' August! H25 then AL25
(Row 25 is the row which falls on August22 date line that's why the data is
pasted Transposed.) Is there a function that can pull the data based on a
entered date into the '2005 Daily Production.xls' worksheet?