Sub Worksheet_Activate()
Application.ScreenUpdating = False
With Sheets("BDD finale")
For L = 2 To .Range("A65500").End(xlUp).Row
If Not IsError(Application.Match(.Cells(L, "A"), Sheets("Source").Range("A:A"), 0)) Then
IndexR = Application.Match(.Cells(L, "A"), Sheets("Source").Range("A:A"), 0)
For C = 2 To 8
.Cells(L, C) = Sheets("Source").Cells(IndexR, C)
Next C
End If
Next L
End With
End Sub