Macro button to move data to relevant worksheets

Hi,

thanks to those who have helped me so far with my workbook. However, I would like to add another sheet to this.

Attached is a simplified workbook. As I will end up with 40 sheets, one for each van that we hire, I am looking to add the data into the data input sheet and then press a button and the relevant data will then go to the relevant sheets.

On the data input sheet, the Reg and Drivers Name is from a list.

So once data has been added, the button would be pressed and then anything for ABCD reg will go to ABCD in the next available row and so on. The data sheet will be cleared once all the data has been moved.

Any help would be appreciated.

Many thanks in advance.