Status column does not change when updated

I hope you will be able to help me with the spreadsheet I have (attached), that has been created and updated over several months and at this stage it is just about running.


You will notice when you open the RCA file, it will ask you to save to a Folder path for the files being saved when created.

The file has details about certain complaints that our customers send through and I have designed the worksheet to make it user friendly for all the Teams to use when their Teams have been submitted complaints.
They are required to answer the questions asked against the Subject complaint.

The Master sheet has 3 worksheets, ToC, Tables, Template.

ToC is the sheet where the Complaints are stored aligned to the folder where they are saved and cell B2 when clicked shows a list of complaint subjects.
Tables is the sheet where the data for the Complaint list is stored under headings, Subject, Why-How Codes, W-H Code and W-H Text
Template is the sheet where the sheet designed is copied when the ToC B2 cell subject is clicked.
The Template sheet has 4 command buttons, 'Add Photo', 'Update Technical', 'Reclose Complaint' & 'Make "InProcess".

Here is the procedure of the worksheet:

1) The Technical Team open the master RCA file and create a Complaint by clicking on the ToC sheet and click on cell B2 which opens a ufSubjects box with a lst of Complaint subject heading.
2) When the Subject has been chosen and clicked 'Ok', it creates a Template sheet where the List of the complaint for the Why-How and W-H Text codes auto display.
3) The Technical Team update the sheet before saving by adding information to the following cells; C4, F4, I4, K4, D6, D7, D8, D9, D10, D13, D14, C15 & C16.
4) The Technical Team then save the file which is stored in the Folder patch.
5) As the Technical Team 1st open the sheet before adding their data to it, you will notice that cell E2 shows Just created, when the Technical Team move to cell F4 for entering data, the cell E2 changes to 'InProcess'.
6) The Teams that have a Complaint then go into the RCA folder and can view which complaint shown is for them to open and then add their data to the sheet.
7) The RCA folder when opened shows how many Complaints that have been created and what the Subjects are, alos it displays who it has been assigned to and where the file or files are stored.
8) By clicking on either the Subject or their name, it will auto open the file for editing.
9) The Teams then add the data to the 'Why' boxes and then save the file.
10) The Status column shows in the beginning when created, 'JustCreated' but when the Team have updated their complaint and saved, it should show (when opened again), 'InProcess' but it still shows 'JustCreated and I cannot get it to change. It used to change before I carried out further updates.
11) The Technical Team open the Complaint to add their comments and this is where the Command buttons come into play.
12) The Technical Team click on the 'Update Technical' button which stops all the other cells being able to edit other that the Technical cells, J7, G9, J15 & J16 (which is called FinishedFlagCell as when double clicked it asks if the complaints wants to be closed and cannot be reopened by anyone other that the Technical Team)
13) When the cell J16 (FinishedFlagCell) has been double clicked it displays a box asking if it wants to close the complaint.
14) When clicked on Ok, the command buttons disappear and the cell E2 changes to closed.
14) If you go into the RCA folder and open the Master, it will still show in the Status column, Jus Created and NOT closed.
15) There is some hidden features in the sheet where ONLY the Technical Team and the creator know about how to change the closed file back into InProcess etc and that is by right clicking on cell C2 and it will show a box stating, 'Open form for changes' and the 4 command buttons re-appear.
16) Also if you delete the subject name from the Master file as though someone was to think it has not been there and saves the sheet again. When opened again, it displays the file from its last update so it cannot be deleted from here and the Status column will show the update, either, 'InProcess' or 'closed'.

I need help on the following:

1) When the sheet has been created and is in JustCreated mode, changes to InProcess when the Technical Team have carried out their updates to show in the Master file when opened.
2) Can the sheet be made any smarter.

I hope that you will be able to help and understand the information I have passed to you.
If there are any question, please ask and I will be gladly to assist.

Many thanks

Pugg