Set up Ongoing copying from one sheet to another sheet in same workbook

Hi All,

In my workbook there are two tabs, One of which contains raw data from a software and is very messy and the other contains neat sorted out data. I need for the data in the secon sheet to be automatically copied into the first sheet arranged into the collums I have set up.

The idea is that the data from the software will be ongoing and all I have to do is input the data into the messy sheet (perhaps by copy & pasting) and then the data should be sorted neatly into collums in the other tab.

Many Thanks All

[I didn't include my workbook as it contains personal info, however I basic workbook to try and test on]