VBA to fill down for multiple data sets, then consolidate data

Hello,

I am seeking the VBA code to fill down data to the last row. But the twist is every eighth column has a different data set that also needs to be filled down. I currently have the basic code:

Sub Fill_Down()
Dim LastRow As Long
LastRow = Cells(Cells.Rows.Count, "A").End(xlUp).Row
Range("e1:g" & LastRow).FillDown
End Sub

The code fills columns E through G properly but how can I cycle through the sheet and then fill columns L through N for the next data set without having to change the range? There are will be more than 25 data sets each with seven columns.

Also, once the data is fill how can I consolidate all of the data sets into 1 data list?

Thanks for any help.


Moderator Edit:

Welcome to the forum.

Please notice that code tags have been added to your post(s). The forum rules require them so please keep that in mind and add them yourself whenever showing code in any of your future posts. To see instructions for applying them, click on the Forum Rules button at top of the page and read Rule #3.
Thanks.