How to save data entry and then merge through Power Query?

[Lacan]

Hello Guys,🖐

Would like your help in order to solve this challenge.
Through a short example below each month have to set up Customer Goals.
How to set up as data entry and then merge data to another major table through Power Query?
Think it could help as few youtube excel videos show have made this major structure.
Feel free to ask more information.
All help is welcome.
Thank you very much!

2025.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P
1											SHEET2
2		CUSTOMER	SELECTED	SALES		ALL						CUSTOMER	MONTH GOALS
3		ABC1		500		CUSTOMER	SELECTED	SALES	MONTH GOALS			ABC1	Product A_6
4		ABC2	S	1000		ABC1	0	500	Product A_6			ABC2	0
5		ABC3				ABC2	S	1000				ABC3	0
6		ABC4	S	400		ABC3	0	0				ABC4	0
7		ABC5	S	2000		ABC4	S	400				ABC5	Product B_10
8		ABC6		50		ABC5	S	2000	Product B_10			ABC6	0
9		ABC7	S	10		ABC6	0	50				ABC7	Product C_4
10		ABC8		11		ABC7	S	10	Product C_4			ABC8	0
11		ABC9	S			ABC8	0	11				ABC9	Product E_4
12		ABC10		8		ABC9	S	0	Product E_4			ABC10	0
13		ABC11	S			ABC10	0	8				ABC11	Product H_95
14		ABC12	S	3		ABC11	S	0	Product H_95			ABC12	0
15		ABC13				ABC12	S	3				ABC13	0
16						ABC13	0	0
17												CUSTOMER	MONTH GOALS
18
19
SAVE DATA ENTRY

Cell Formulas
Range	Formula
L3:L15	L3	=CHOOSECOLS(F4#,1)
M3:M15	M3	=XLOOKUP(CHOOSECOLS(L3#,1),F4:F16,I4:I16,0)
F4:H16	F4	=FILTER(Tabela356,IF(F2="WITH SALES",Tabela356[SALES]>0,IF(F2="ALL",Tabela356[SALES]>=0)))
Dynamic array formulas.

Cells with Data Validation
Cell	Allow	Criteria
F2	List	WITH SALES; ALL