Changing status to next level based on a selected drop-down

[tweater]

Hi everyone. I am having a hard time attaching the file here but I uploaded it in temp share. When you go to the 2nd work sheet, I've got everything to work using a Macro except for one item which is cell F11. I need that to go along with my Macro command where, the soonest I assign the code, it updates the status of that specific code on the master list sheet based on what is in F11. Thanks for your help.

Temp Share : project tweat.xlsm | Free temporary file hosting