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

[martinofyre]

The data:

<tbody>
</tbody>

	A	B	C	D	E	F
1	2018
2	2018	JAN	JAN	JAN	JAN	JAN
3	2018	05/01/2018	12/01/2018	19/01/2018	26/01/2018	02/02/2018
4	2018	1	2	3	4	5

<tbody>
</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,"")