Comment saisir la valeur d'une variable dans une cellule d'une autre feuille

Private Sub Indexer_Click()
Dim L1&, N, D, S, F, SF
With Worksheets("Fiche technique")
    N = .Range("A6").Value
    D = .Range("C7").Value
    S = .Range("H9").Value
    F = .Range("H11").Value
    SF = .Range("H13").Value
End With
With Worksheets("Index Fiche Technique")
L = .Range("A" & Rows.Count).End(xlUp).Row + 1
    .Cells(L, 1).Value = N
    .Cells(L, 2).Value = D
    .Cells(L, 3).Value = S
    .Cells(L, 4).Value = F
    .Cells(L, 5).Value = SF
End With
End Sub

Private Sub Indexer_Click()
Dim L As Long, T(1 To 1, 1 To 5) As Variant
L = Feuil5.Cells(Feuil5.Rows.Count, "A").End(xlUp).Row + 1
T(L, 1) = Me.Cells(6, "A").Value
T(L, 2) = Me.Cells(7, "C").Value
T(L, 3) = Me.Cells(9, "H").Value
T(L, 4) = Me.Cells(11, "H").Value
T(L, 5) = Me.Cells(13, "H").Value
Feuil5.[A:E].Rows(L).Value = T
End Sub