I'm new an still have very much to learn. I will try to explain. We use drop box and have folders set up, We have a folder called new job within that folder or several folders and work books. Once a new job is started the folder is copied and remained for the new job. All the work books are in the main folder. I have one that is master job this workbook has all the job info. I have been able to link the data needed to the other work books, such a name permit number start and end date etc. As an example the work book for weekly reports I would like to put into the report folder. When I do the data links back to the main folder are broken. I would be open to doing a screen share to better explain.
