Macro To Select All Rows Above Cell That Satisfies Condition?

In a particular sheet the data (with formulae) are present from rows E5:Q5000. I require a macro which automatically does the following:

- When user enters “submitted” in the row Column N, entire rows above that cell should be selected, and copy-pasted as values to remove all formulas. So if user enters “submitted”, at N31, then data set E5:Q31 should be selected and copy pasted special so as to retain only values.

-Finally the copy pasted data should be sorted as per the status of Column N.