Variable range copy paste

Hi all. My first post so thanks in advance.
I have a excel doc that contains a list of names, say 10 columns. I need to move these into a new sheet under different headings.
The column data always starts at row 10 due to headers and other data that is required.
The rows sizes are always different depending on how many people attend an event.
I will be running each row independently so if I could get an example using the following I may well be able to do the rest.
Lets get their names;
Sheet2 Column B At Row 10
Move to Sheet1 Column L Row 4
I am quite happy using VBA
Thanks
Scott

yep 10/10
Works great. Many thanks for helping me out
Cheers Scott

Hello again
Just realized that you will need to remove the old list in Sheet1 before copying the new one, else you may get remnants of the old list if the sizes vary, so I've removed my original attachment and replaced it with this amended one.

Sorry for any confusion.

DBY

Thanks for the update. Sorry took so long to get back.
Appreciate you following that up. All the best Scott