Until an hour of research ago, I didn't know what Mail Merge is. I am an IT Consultant, not an Excel and Word guru. That being said, I need to understand some of the basic functionality of Excel so that I can apply them to a business that I am working for.

1. How do I link data from Excel cells into a Word document
2. How do I link data from a Word document into a different point of a Word document
3. How do I fill an Excel cell with the contents of a file folder

I have three documents. I have a bill, a contract, and a log. The bill requires numbers to be input and rates to be calculated. The bill contains customer information that needs to be pushed to the contract. The customer information should also be pushed to the log. I want to remove this redundant typing of information. The file names are not always the same, but if I need to establish that policy that is possible. I was thinking of creating a bill template and a contract template that link to each other to communicate customer information and having the log update itself to display the contents of the file folder. The bill and contract will be in the same folder as the log, and the bills and contracts will have customer names on them and save dates to show progress. I could also have the contract generated by a VBA script or whatever AFTER I have filled out the bill.

Is there an Excel feature to track changes in a folder? Is there some sort of logging system I should look into for this?

I don't know if this will have an easy answer or a complex answer. I would be willing to PayPal someone for the work to get this done, because I don't want to waste this company's time figuring it out.