Macro formula for copy cell value from files excel to one workbook

Dear sir/miss,
I do have a lot of work today, I need some help for this forum to speed up my target finished.

Actually I do want to copy cell N589 from all files excel (sheet1) in c:\database\2014\ to my workbook click run into the row C.

is there any of you can solve it?


Thank