جرب هذا الكود
Sub extract_data()
Dim x, i, lr As Integer
Dim My_sheet As Worksheet
Dim Source_sheet As Worksheet
Set Source_sheet = Sheets("البيانات")
Set My_sheet = Sheets("ارقام الجلوس")
Application.ScreenUpdating = False
Application.Calculation = xlCalculationManual
My_sheet.Columns(2).ClearContents
My_sheet.Columns(5).ClearContents
lr = My_sheet.Cells(Rows.Count, 1).End(3).Row
x = 1
For i = 2 To lr
My_sheet.Range("b" & x).Resize(5, 1) = Application.WorksheetFunction.Transpose(Source_sheet.Range("a" & i).Resize(1, 5))
My_sheet.Range("b" & x + 4).NumberFormat = "m/d/yyyy"
My_sheet.Range("e" & x).Resize(5, 1) = Application.WorksheetFunction.Transpose(Source_sheet.Range("a" & i + 1).Resize(1, 5))
My_sheet.Range("e" & x + 4).NumberFormat = "m/d/yyyy"
i = i + 1
x = x + 6
Next
Application.ScreenUpdating = True
Application.Calculation = xlCalculationAutomatic
End Sub