Sub Rectangle1_QuandClic()
Dim i As Integer
Dim n As Integer
n = 1
While n < 4
For i = 2 To 8
If Application.Weekday(Sheets(n).[B1]) = Sheets('s1').Range('A' & i) Then
Sheets('s1').Range('C' & i) = Sheets('s1').Range('C' & i) + Sheets(n).Range('B3')
End If
Next i
n = n + 1
Wend
End Sub