How to Copying data from master file to other Spreadsheet

Hello Friends,

I have made Master file basically allow the user to enter data,

This works fine and will keep adding records onto the sheet...but ideally i would like to data to be copied and saved to another sheet in another workbook - seperate to this one according to the user name(s).

Suggestions on the relevant code would be great. Please find attached my attached file.

Help on this will be much appreciated.

Many Thanks in advance for your help..
Marc