I have 5 status cells with a validation. I would a cell to tell me what the updated status is.

example

Cells
J11
J15
J19
J23
J27

If J27 = "" Then Go To J23

Else If J27 <> "" Then
If J27 = "AVAILABLE", "RETIRE", OR "SHIPPING" tHEN Range("AA1") = Value

Else ("AA1") = "WIP"

If J23 = "" Then Go To J19

Else If J23 <> "" Then
If J23 = "AVAILABLE", "RETIRE", OR "SHIPPING" tHEN Range("AA1") = Value

Else ("AA1") = "WIP"

If J19 = "" Then Go To J15

Else If J19 <> "" Then
If J19 = "AVAILABLE", "RETIRE", OR "SHIPPING" tHEN Range("AA1") = Value

Else ("AA1") = "WIP"

And so on until J11 At some point it should find something and then when Saved it will look at Cell AA1 and know the latest update.