VBA code for document controll & progress monitoring

You have to use some public file share site and post back the link to the FILE ITSELF back here

So is it correct to say that you want to have some thing that can update the date and time
Does the file that you get from the contractor has same information.

Most easy way that comes to my mind is that, you have on each file a sheet that contain all the information that you want to be pulled out. So user only update that sheet. You macro can then loop through all the workbooks. Since you said it is engineering stuff, I am guess not all documents are not workbook

Presuming that the "PIB" part is locating and updating the values, the alternate way could be that in a new sheet you enter the document id and the date and some code to indicate that this date refers to what milestone, then you can have a macro that uses this list, match up the document id and update the dates

I am sorry but now I am bit more lost. The workbook that you posted, I am presuming is the master sheet. How does contractor sheet would look like from where the information needs to be copied. Since you want information to be lifted off the contractor copy of document, one has to see how two can be tied together