Help me with copy paste macro please

[Jyggalag]

Hi All,

I would like a to get a VBA code that, once I press it, looks at cell D5 and then copy pastes the formula from BW34:BW36 to BX34:BX3, as well as from BX41:BX50, because cell BX6 is >= 2.
The next month, when cell D6 is updated to the number 3, it should update column BY as well.

Please see the image below. Also uploaded excel copy paste below the image.

Let me know if you have any questions - it would be greatly appreciated!

Current Month 2025	2
1	2	3	4	5	6	7	8	9	10	11	12
JAN 2025	FEB 2025	MAR 2025	APR 2025	MAY 2025	JUN 2025	JUL 2025	AUG 2025	SEP 2025	OCT 2025	NOV 2025	DEC 2025	Total 2025
TEXT	TEXT	TEXT	TEXT	TEXT	TEXT	TEXT	TEXT	TEXT	TEXT	TEXT	TEXT
TEXT	TEXT	TEXT	TEXT	TEXT	TEXT	TEXT	TEXT	TEXT	TEXT	TEXT	TEXT	TEXT
FORMULA												-
FORMULA												-
FORMULA												-
-	-	-	-	-	-	-	-	-	-	-	-	-
TEXT	TEXT	TEXT	TEXT	TEXT	TEXT	TEXT	TEXT	TEXT	TEXT	TEXT	TEXT
TEXT	TEXT	TEXT	TEXT	TEXT	TEXT	TEXT	TEXT	TEXT	TEXT	TEXT	TEXT	-
-												-
FORMULA												-
FORMULA												-
FORMULA												-
FORMULA												-
FORMULA												-
FORMULA												-
FORMULA												-
FORMULA												-
FORMULA												-
-	-	-	-	-	-	-	-	-	-	-	-	-