@ Laetitia,

Go to the worksheet tab,
right click to menu sub menu,
select View Code
and copy event macro :

Private Sub Worksheet_Deactivate()
Sheet1.Cells.Copy Destination:=Sheet2.Range("A1")
End Sub

@ Gord ,
You are obviously right ...
But in my humble opinion, to fully replicate a sheet with values and
formats, there is no real alternative ...
Don't you think so ?