Copy Range into blank column

Hello,

I’m looking to copy a fixed range into the closest blank column in excel.

How can this be done.

I also want to create a new sheet and rename it with the number after the one before it. IE sheet 1 then add another named sheet 2