Every year I deal with 15-20 separate bid packets from several departments. I have set up my files so I can simply copy a "Master Folder" into a new project folder and have all the documentation and legal mumbo-jumbo needed for each bid packet included. This eliminates the chance I will miss something when starting up a new project.

I am looking for a simple way to update similar data in all the documents within my project folder (i.e. bid opening date, project name, contact information, etc.). By linking these fields to a "project information sheet" I will reduce the hours of sifting through each document to update the information and eliminating any input errors.

I know my file structure sounds weird, but I have several funding sources along with different bid I think this will work well for my situation. If I can only make it read the project information sheet in the project folder and not the original stored in my master folder.

Thanks for your help and input, I always welcome new fresh ideas to my mayhem.