Custome Sort By Value on 2 Pages

Hi all,

I am trying to sort my row data with two column values.
To start my data is already sorted or grouped by numerical values
in column "A" of my sheet named "Non_Completed".

I want to keep the rows sorted/group by these numerical values.

Next I have a workbook named Job_Status_Update. On Sheet 1
in column "A" I have a job ID # consisting of a 3 digit value (ie: 4PZ)
They are listed as row 1 (most important) to last row (of least importance).

These values can be found on my Non_Completed sheet in column "E"

For each value found on my Non_Completed that listed on my Sheet 1
of the Job_Status_Update, I need it to sort them within each numerical group according to level of importance
(Or sort from Top to Bottom Order found on the Job_Status_Update.xls,Sheet1).

If the value is not found it will place the row at the bottom of each numerical group.

Any help doing this is appreciated.

Thanks,

BDB