Show the latest Cell Value of a column in the other cell of worksh
 

Hello to alll
I have 5 codes (contain text and number) in a column:
A1= F 01 01
A2= F 01 02
A3= F 01 03
A4= F 01 04
A5= F 01 05
But they are not completed at one time. they are completed at some times
orderly.
I need to see the latest filled cell (Latest code) in a cell on the other
worksheet.
Is there a function for it?
Much thnaks
Amir