VBA - Appending Weekly Worksheet Data To Master Sheet

I've a workbook with two sheets 1)'weekly' and 2)'summary.'

Weekly is divided into products (up to a maximum of 8) with a fixed number of columns (4) directly below but a varying number of rows beneath as follows:

Product A (main header)
Issue|Serial Number|Analysis|Comments
data|data|data|data
data|data|data|data
data|data|data|data
data|data|data|data

--couple of blank rows--

Product B
Issue|Serial Number|Analysis|Comments
data|data|data|data
data|data|data|data
data|data|data|data

--couple of blank rows--

Product C
Issue|Serial Number|Analysis|Comments
data|data|data|data
data|data|data|data
data|data|data|data
data|data|data|data
data|data|data|data
data|data|data|data

..etc...

This weekly data must be appended into each product's respective grouping within the 'Summary' tab. With the following small additions: 2 additional columns filled with the model and current week must be inserted beforehand:

Product C
Model|week|Issue|Serial Number|Analysis|Comments
Product C|7|data|data|data|data
Product C|7|data|data|data|data
Product C|7|data|data|data|data
Product C|7|data|data|data|data
Product C|7|data|data|data|data
Product C|7|data|data|data|data

Summary page will contain the groupings of Product A through H. The weekly may only contain 1 (say Product D) in any given week, or all 8.

I realize there are more efficient ways of doing this, i.e. pivot tables, creating discrete tabs for each product, etc... but I've been tasked by the higher-ups to generate the above as I've laid out.