help adjusting code delete empty rows based on condition from sheet1 to sheet2

[maghari]

Option Explicit

Sub TransferData()
Dim TargetRow As Long
Dim LastRow As Long
Dim Rw As Long
Dim rSource As Range
 
LastRow = Sheet1.Cells(Rows.Count, "A").End(xlUp).Row
TargetRow = Sheet2.Cells(Rows.Count, "A").End(xlUp).Offset(1).Row
  
For Rw = 2 To LastRow
   Set rSource = Sheet1.Range(Sheet1.Cells(Rw, 1), Sheet1.Cells(Rw, 5))
   If rSource.Cells(1) <> "" Then
      rSource.Copy
      Sheet2.Cells(TargetRow, "A").PasteSpecial Paste:=xlPasteValues
      TargetRow = TargetRow + 1
   End If
Next Rw
End Sub

thanks your code really work but not as i want i would transfer data the same formating table
a i attache my file to understand more


https://ufile.io/39xbgskh