VBA Simple Copy and Paste between two workbooks based on criteria

[fixer]

we have to Open all the files all files are closed except the vba placed file
If column E of school.xlsx matches with column A of school2.xlsx then copy column E of school2.xslx and paste it to column Z of school1.xlsx and save and close all the files(close school1.xlsx and close school2.xlsx)
macro will be attached to a different file
all files are located in same place
example
cell E20 of school1.xlsx matches with column A10 of school2.xlsx then copy E10 of school2.xlsx and paste it to Z20 of school1.xlsx
Plz have a look i have attached my sample file also

---

Edit:
See post #3 .. http://www.excelfox.com/forum/showth...ll=1#post11433
school1.xlsx is ap.xls
school2.xlsx is leverage.xlsx (LEVERAGE1.xlsx )