How To Change Paste Destination Range

I have a existing code which copies data from one 6 workbooks to Main workbook.

Copying data from workbook 1:

It has Header at 2nd row and Data starts from 3rd row.

From A column to AG

Destination workbook: In this workbook. I have Header at 26th row From A to AG copied Data needs to be pasted at 27th row.

And like wise while continuing to copy datas from other workbook it will get added at last.

My code is working fine. But my requirement here is at Destination area.

Now i have moved Header in Destination workbook. Header is at 26th row
From A To Ag to D to AJ
Data needs to get added at bottom of each paste.

HTML Code: 

rowofcopysheet = 3

Set copyrng = wkb.Sheets(1).Range(Cells(rowofcopysheet, 1), Cells(Cells(Rows.Count, 1).End(xlUp).Row, Cells(1, Columns.Count).End(xlToRight).Column))
Set Dest = shtDest.Range("A" & shtDest.Cells(Rows.Count, 1).End(xlUp).Row + 1)

copyrng.Copy
Dest.PasteSpecial xlPasteValuesAndNumberFormats