if cell equals "value" then return that entire row to another row in the same sheet

Hello,

I am a newbie at excel, so I would probably need pretty basic instructions. What I'm looking at doing is moving a complete row of information once each cell on that row has a value and copy to another row of the same sheet. To be exact, the last row with information (ex. row #20), once filled, I want it to automatically be copied on row #4 (which would have the latest updated information) If the next row, row #21 is filled, then the information on row #4 needs to change.

thanks for your help

Pier

I have 24 columns. top 4 rows panes have been frozen, as if I continue to put information and scroll down, I always want to be able to see those.

I'm sorry, data starts from row #5 like you mentioned, but it goes into row #3. Is there anything that changes?

Here is the Excel sheet.