Insert range of cells based on matching two cells - No VBA

[martinofyre]

The data:

<tbody>
</tbody>

<tbody>
[TD="class: xl72, width: 61"]A[/TD]
[TD="class: xl72, width: 61"]B[/TD]
[TD="class: xl72, width: 61"]C[/TD]
[TD="class: xl72, width: 61"]D[/TD]
[TD="class: xl72, width: 61"]E[/TD]
[TD="class: xl72, width: 61"]F[/TD]

[TD="class: xl73, align: right"]1[/TD]
[TD="class: xl74, width: 61"]2018[/TD]
[TD="class: xl75, width: 61"][/TD]
[TD="class: xl75, width: 61"][/TD]
[TD="class: xl75, width: 61"][/TD]
[TD="class: xl75, width: 61"][/TD]
[TD="class: xl75, width: 61"][/TD]

[TD="class: xl73, align: right"]2[/TD]
[TD="class: xl74, width: 61"]2018[/TD]
[TD="class: xl75, width: 61"]JAN[/TD]
[TD="class: xl75, width: 61"]JAN[/TD]
[TD="class: xl75, width: 61"]JAN[/TD]
[TD="class: xl75, width: 61"]JAN[/TD]
[TD="class: xl75, width: 61"]JAN[/TD]

[TD="class: xl73, align: right"]3[/TD]
[TD="class: xl74, width: 61"]2018[/TD]
[TD="class: xl76, width: 61"]05/01/2018[/TD]
[TD="class: xl76, width: 61"]12/01/2018[/TD]
[TD="class: xl76, width: 61"]19/01/2018[/TD]
[TD="class: xl76, width: 61"]26/01/2018[/TD]
[TD="class: xl76, width: 61"]02/02/2018[/TD]

[TD="class: xl73, align: right"]4[/TD]
[TD="class: xl74, width: 61"]2018[/TD]
[TD="class: xl74, width: 61"]1[/TD]
[TD="class: xl74, width: 61"]2[/TD]
[TD="class: xl74, width: 61"]3[/TD]
[TD="class: xl74, width: 61"]4[/TD]
[TD="class: xl74, width: 61"]5[/TD]

</tbody>

The requirement:
If A2,A3,A4 = A1 then insert rows 2,3,4 starting column B into rows 6,7,8 starting column B

This needs to be done across many years so looking for an HLOOKUP or INDEX and MATCH to achieve this.
No VBA solutions please if possible.

Thanks for any help.

 

[Scott T]

If all three cells must be = to A1 then

Excel 2010
	A	B	C	D	E	F
1	2018
2	2018	Jan	Jan	Jan	Jan	Jan
3	2018	1/5/2018	1/12/2018	1/19/2018	1/26/2018	2/2/2018
4	2018	1	2	3	4	7
5
6		Jan	Jan	Jan	Jan	Jan
7		1/5/2018	1/12/2018	1/19/2018	1/26/2018	2/2/2018
8		1	2	3	4	7
Sheet4

Cell Formulas
Range	Formula
B6	=IF(AND($A$2=$A$1,$A$3=$A$1,$A$4=$A$1),B2,"")
B7	=IF(AND($A$2=$A$1,$A$3=$A$1,$A$4=$A$1),B3,"")
B8	=IF(AND($A$2=$A$1,$A$3=$A$1,$A$4=$A$1),B4,"")
C6	=IF(AND($A$2=$A$1,$A$3=$A$1,$A$4=$A$1),C2,"")
C7	=IF(AND($A$2=$A$1,$A$3=$A$1,$A$4=$A$1),C3,"")
C8	=IF(AND($A$2=$A$1,$A$3=$A$1,$A$4=$A$1),C4,"")
D6	=IF(AND($A$2=$A$1,$A$3=$A$1,$A$4=$A$1),D2,"")
D7	=IF(AND($A$2=$A$1,$A$3=$A$1,$A$4=$A$1),D3,"")
D8	=IF(AND($A$2=$A$1,$A$3=$A$1,$A$4=$A$1),D4,"")
E6	=IF(AND($A$2=$A$1,$A$3=$A$1,$A$4=$A$1),E2,"")
E7	=IF(AND($A$2=$A$1,$A$3=$A$1,$A$4=$A$1),E3,"")
E8	=IF(AND($A$2=$A$1,$A$3=$A$1,$A$4=$A$1),E4,"")
F6	=IF(AND($A$2=$A$1,$A$3=$A$1,$A$4=$A$1),F2,"")
F7	=IF(AND($A$2=$A$1,$A$3=$A$1,$A$4=$A$1),F3,"")
F8	=IF(AND($A$2=$A$1,$A$3=$A$1,$A$4=$A$1),F4,"")

If it is row by row then

Excel 2010
	A	B	C	D	E	F
1	2018
2	2018	Jan	Jan	Jan	Jan	bob
3	2018	1/5/2018	1/12/2018	1/19/2018	1/26/2018	2/2/2018
4	2018	1	2	3	4	7
5
6		Jan	Jan	Jan	Jan	bob
7		43105	43112	43119	43126	43133
8		1	2	3	4	7
Sheet4 (2)

Cell Formulas
Range	Formula
B6	=IF($A2=$A$1,B2,"")
B7	=IF($A3=$A$1,B3,"")
B8	=IF($A4=$A$1,B4,"")
C6	=IF($A2=$A$1,C2,"")
C7	=IF($A3=$A$1,C3,"")
C8	=IF($A4=$A$1,C4,"")
D6	=IF($A2=$A$1,D2,"")
D7	=IF($A3=$A$1,D3,"")
D8	=IF($A4=$A$1,D4,"")
E6	=IF($A2=$A$1,E2,"")
E7	=IF($A3=$A$1,E3,"")
E8	=IF($A4=$A$1,E4,"")
F6	=IF($A2=$A$1,F2,"")
F7	=IF($A3=$A$1,F3,"")
F8	=IF($A4=$A$1,F4,"")