<cell value> = number of rows to display after a given row, then copy row down <cell value> times

[nadia p]

I'm trying to create a dynamic form where by information is pulled from another worksheet and displayed in a master report. I have a cell that contains the number of transactions found based on FROM and TO dates (i.e. 3 transactions found between these dates).

From	01/01/19
To	01/31/19
Transactions	3
Date	Description	Qty.	Cost
z1	z2	z3	z4
		Subtotal	$

<tbody>
</tbody>

The row where z1, z2, z3, z4 reside I need to first copy this row below 2 more times, then copy the formulas from z1, z2, z3, z4 down as well to replicate the 10 transactions of data being pulled from the other worksheet.

From	01/01/19
To	01/31/19
Transactions	3
Date	Description	Qty.	Cost
z1.a	z2.a	z3.a	z4.a
z1.b	z2.b	z3.b	z4.b
z1.c	z2.c	z3.c	z4.c
		Subtotal	$

<tbody>
</tbody>

Later the user can modify the FROM / TO dates and it will look up the number of transactions so the "displayed rows" needs to update dynamically to the new value (i.e. 5).

I haven't figured out how to do this without braking the information (array) in the z* cells.

Any ideas?