Macro Reqd to update Purchase order log, everytime a new purchase order is made

Excel Experts,
I am from the Construction Industry and I want to set up a Purchase order Log by summarizing purchase orders already made or that will be made in the future. Every Purchase order will represent an independent Workbook in a folder say C:/Job-2300/PO#001. I want the log to be updated( which is a different workbook altogether) automatically every time the purchase order is made pulling all necessary information as required. Can this be done?
Please Find the attached files
Please Advice.
Thanks