Copy and Paste data to another sheet

[Vtookup]

Hi. Need help with VBA to Copy data to another sheet
I have summary sheet that will transfer data to grand total sheet as Values.
"Summary" sheet range (B4:F13). Row 3, have headers.
"Grand Total" sheet is empty that will accumulate what is Pasted from "Summary" sheet ("Grand Total" sheet Row 1 have headers).
each time new data are added, it have to be next row of old data.
Thank you in advance for assistance.

 

[Vtookup]

Hi. got this from Copy Selected Data and Paste to the Last Row of Another Sheet
Yongle's
Sheets("Master").Range("A1:S1").Copy
With Sheets("Copy").Range("A" & Rows.Count).End(xlUp).Offset(1)
.PasteSpecial (xlPasteAll)
.PasteSpecial (xlPasteValues)
End With
This is helpful. substituted Range to B4:E13.
If i transfer 10 rows of data. the code works fine. if i have less row than ten, then there's gaps. empty rows before next data transferred.
this is beyond substitution of variants. no knowledge with vba. need help to modify this statement
(Sheets("Master").Range("B4:E13").Copy) to be flexible with lesser rows
also i have included
Application.CutCopyMode = False
Range("A1").Select. can A1 be substituted with cell from next empty row?
Thank you in advance.