Connected tables behavior when refresh data

[Carlos Matioli]

Hello everyone. I created a master table where I set IDs, and used "Existing Connections" to create another table (Table B) using this method

https://www.reddit.com/r/excel/comments/fdhv03/how_do_i_make_a_table_expand_when_another_table

, where I created additional columns and insert more information about these IDs. The thing is, if I insert new data in the master table and refresh the data, the infos I added previously in the Table B jump to the new last line.
This also happens when I add IDs to the middle of the table also; the data added manually in Table B don't dislocate with it's ID.
Is this the normal behavior? How do I prevent this from happening?
My intention with this is when I add an ID in one table, multiple tables automatically add the lines, but keep the previous info with it's IDs. Is it possible in Excel?

Teste.xlsx
	A	B	C	D
2	Source Table
3	Item	ID_Circ	Painel	Circuito
4	1	QGBT-01/S1_1D1	QGBT-01/S1	1D1
5	2	QGBT-01/S1_1D2	QGBT-01/S1	1D2
6	3	QGBT-01/S1_1D3	QGBT-01/S1	1D3
7	4	QGBT-01/S1_1D4	QGBT-01/S1	1D4
Sheet1

Cell Formulas
Range	Formula
B4:B7	B4	=TEXTJOIN("_",FALSE,[@Painel],[@Circuito])

Teste.xlsx
	F	G	H	I
2	Connected Table
3	Item	ID_Circ	Info1	Info2
4	1	QGBT-01/S1_1D1
5	2	QGBT-01/S1_1D2	A	B
6	3	QGBT-01/S1_1D3	C	D
7	4	QGBT-01/S1_1D4	E	F
Sheet1