Sorry not very self explanatory.

the easiest way to to this is to record a macro.

Assuming you have a developer tab on excel, press that then click on record macro. [ remember the macro name ]

Go through the steps that you want to take,
Move to sheet 2, then to sheet one so that excel know where to start
Select & Copy the data you want copied across
Select Sheet Two

Select the cell you want it pasted to and paste.

Clear any cells you want cleared

Type in any formulas that you want typed.

Then

press the developer tab and press Stop macro.

on the developer tab press insert

and click on the icon on the top left of the little window

click and drag anywhere on your spreadsheet will create a button

Right click on that and press assign macro to link the button to your macro,


Now if you want the macro tidied up or improved. come back to me.