[Solved]Copy data from External Files Referenced in column A

I am using Windows 7 with Excel 2007. I am new at this and would appreciate any help given.

My master workbook has in column A filenames (over 100) for each row of data (ie C:\Users\David\Desktop\Experimental\2-a\2-A HAY PRODUCTION-dg2.xlsm) I need a formula that will open each file listed in column A and copy the contents of cell $D$2 to the active worksheet cell B2 etc.