Having problems updating a workbook based on values from many other workbooks

[gibson2503]

WINKLER,ANDREA M.xlsxSTAFF LIST.xlsm

I have a bunch of workbooks. Each of them is named by employee. Each of them has two worksheets, one for each fiscal year. I also have a workbook named STAFF LIST with macros enabled. On STAFF LIST, I want to end up with one line for each employee workbook. On each employee's line, I want the name in column A. In columns B, C, D, and E, I want the values from that employee's workbook FY 2012 worksheet, cells K31, L31, M31, and N31. In columns F, G, H, and I, I want the values from that employee's workbook FY 2013 worksheet, cells K31, L31, M31, and N31. I used the VBA code that is in the STAFF LIST workbook, but it did not work. Instead of copying K31 through N31 on each employee workbook, it copied K31 through N31 on the active sheet in STAFF LIST. STAFF LIST and one of the employee workbooks are attached to this. Please help me out with my VBA code so it will do what I need to do.