Need to create a button that can copy cells, create a new sheet and then paste there

So I've got Sheet 1 with say

____A___B___C
1___m___i___c
2___r___o___s
3___o___f___t

I would like to create a button that can create a new sheet and paste A1 to C3 at the same location on the new sheet

and I need this to create a new sheet and do that everytime the button is pressed

can someone help me with this?




I've tried creating a shape and assigning a recorded macro to it where i did this:
1. create a new sheet (this part worked)
2. copy data (this worked)
3. pasted onto new sheet (did NOT work, instead it kept pasting onto the same sheet and 2 lines below the older version)