Copy Range into blank column


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