VBA involving macro and client ID

[currypowder]

Hi,

I have a userform called "delete_client". Once it is opened, it comes up with a simple text box, which I wish to be used so that when my client inserts a specific user ID I.e. CDo0001, all the information kept about that user will be delete. The information about that user is kept on cells L13-O13 in a table, with the user ID kept on cell P13. However, when new users are inserted onto the table, the user will be shifted to the row below and the new user will be created.
I wish so that when the client ID is inserted into the Delete Client user form, then the cells associated with the client will be moved to another sheet (Sheet 4), on a new table called Deleted Clients,

Thanks in advance