Update Userform Template List

I have been searching the web for a solution with no success
If I open my userform template to create a new workbook on the userform and select an item from a combo box all data will be saved to the new workbook when i name and save it on close. If i need to add additional items to the list i have a popup userform to add the item which updates the combobox list on the new workbook. How do I get it to update the original userform template list so next time I open the userform template to create a new workbook the item will show in the combobox list

Roy

I have attached my workbook so hopefully you can see what i am trying to achieve. I have different worksheets within the existing workbook which are defined name lists. What i need to be able to do is when i open the original workbook to create new workbook under a new job number any add additional data through userforms with combo boxes that is add to the defined lists is updated to the original workbook when I save the new workbook.

Roy

Are you saying that I can save all the additional workbooks that will be created by job numbers in the Master Workbook if so that would be great. I am a novice at this VBA stuff

Roy

How would i go about doing what you suggested and would my Project Summary form still show individual job numbers data

Yes each job has its own workbook this is the reason why i was suggesting that any additions to the Defined Names List on individual workbooks would need to be updated to the template workbook list as well

What we are doing is recording all data associated with the job and comparing it to what was budgeted
for each component of the job. This is displayed on the Project Summary Form

Each job will saved to a folder in my documents called Project Costs. These job numbers will be opened on a daily bases to add additional data and then saved bac to the folder