Fill cells based on occurrence of first match vertically, multiple columns

Hi

This is a little tricky to explain so I add both picture and xlsx file
I want to consolidate 3 (or more) columns into one column, based on the latest cells value that occurs in an array. From top to bottom for each row. Most cells are empty, and there is only one value on each horizontal line. I'd like to fill (populate) a consolidated column based on the latest cell.

Conditions
More rows will be entered every day. But a formula in column E is ok to use and copy downwards.
Consolidate into column E,
AND
fill the empty cells based on the previous value of any of the 3 columns. - I don't know how to do this part.

Excelforum_fill_from_closest_cell_when_condition.xlsx

Screenshot 2024-01-14 144631.jpg

Regards