copy last column for each sheet and the ID for each adjacent cells

[tubrak]

Hi,

I want to populate report in OUT sheet by copy all of ID across sheets and copy the last column for each sheet , but don't repeat copying the last column has already copied .

every time I add new sheet before OUT sheet and should put the value into adjacent cell based on matching ID when copy the last column for each sheet .
.

TB.xlsm
	A	B	C	D	E	F	G
1	S.N	ITEM	QTY	01/12/2023	02/12/2023	03/12/2023	04/12/2023
2	1	TR 200M45MM LK H K/L	22.00	11.00	11.00	2,555.00	30.00
3	2	TR 200M451 NMM LK H K/L	23.00	12.00	10.00	22.00	40.00
4	3	TTR 12200S45 MN 123	120.00		2.00	33.00	50.00
5	4	CTR 12-200M45 MM 123H K/L	100.00		3.00	45.00	10.00
6	5	CCTR 12-200M45 MM 123H K/L	120.00	11.00	33.00	88.00	20.00
7	6	TR 1425/148V MN 123H K/L	220.00	15.00	22.00		60.00
8	7	TR 200M45 MM 123H K/L SS	230.00	16.00	44.00		70.00
9	8	VSRT 258000 MJ L/66	20.00	220.00	120.00		80.00
10	9	TR 2.5M100**123H K/L	20.00	18.00	20.00	11.00	90.00
11	10	TRMN 22.5M100* 123H K/L	21.00	19.00	21.00	22.00	100.00
12	11	TTRM 12200S45 MN 1234	22.00	20.00	22.00	11.00	110.00
13	12	TTRR 1200S45 MN 123	23.00	21.00	23.00	55.00	120.00
14	13	TR 1200M45MM LK H K/L	24.00	22.00	24.00	88.00	130.00
15	14	BTR-100***8 RRT-DE34230	25.00	23.00	25.00		140.00
16	15	BTR-100***8 RRT-DE34231	26.00	24.00	26.00		150.00
17	16	BTR-100***8 RRT-DE34232	27.00	25.00	27.00		160.00
18	17	TR 2.5M100**123H K/LM	30.00	28.00	30.00		190.00
19	18	VMTR 1200S45 MN 123	31.00	29.00	31.00		200.00
20	19	JKLLL2333 JK/800	32.00	30.00	32.00		210.00
21	20	RTTTM899 HJ80 12/30	33.00	31.00	33.00		220.00
sheet1

TB.xlsm
	A	B	C	D	E	F	G	H
1	S.N	ITEM	QTY	01/01/2024	02/01/2024	03/01/2024	04/01/2024	05/01/2024
2	1	CTR 12-200M45 MM 123H K/L	12.00	10.00	12.00		10.00	22.00
3	2	TR 200M45 MM 123H K/L SS	18.00	16.00	18.00		70.00	28.00
4	3	TR 200M45MM LK H K/L	14.00	12.00	14.00		30.00	24.00
5	4	TR 200M451 NMM LK H K/L	15.00	13.00	15.00		40.00	25.00
6	5	TTR 12200S45 MN 123	16.00	14.00	16.00		50.00	26.00
7	6	TR 1425/148V MN 123H K/L	17.00	15.00	17.00		60.00	27.00
8	7	TR 2.5M100* 123H K/L	19.00	17.00	19.00		80.00	29.00
9	8	TR 2.5M100**123H K/L	20.00	18.00	20.00		90.00	30.00
10	9	TRMN 22.5M100* 123H K/L	21.00	19.00	21.00		100.00	31.00
11	10	TTRM 12200S45 MN 1234	22.00	20.00	22.00		110.00	32.00
12	11	TTRR 1200S45 MN 123	23.00	21.00	23.00		120.00	33.00
13	12	TR 1200M45MM LK H K/L	24.00	22.00	24.00		130.00	34.00
14	13	BTR-100***8 RRT-DE34233	28.00	26.00	28.00		170.00	38.00
15	14	BTR-100***8 RRT-DE34231	26.00	24.00	26.00		150.00	36.00
16	15	BTR-100***8 RRT-DE34230	25.00	23.00	25.00		140.00	35.00
17	16	BTR-100***8 RRT-DE34232	27.00	25.00	27.00		160.00	37.00
18	17	TR 2.5M100**123H K/LM	30.00	28.00	30.00		190.00	40.00
19	18	BTR-100***8 RRT-DE34234	29.00	27.00	29.00		180.00	39.00
20	19	CCTR 12-200M45 MM 123H K/L	13.00	11.00	13.00		20.00	23.00
21	20	VMTR 1200S45 MN 123	31.00	29.00	31.00		200.00	41.00
22	21	CCMTR 12-200M45 MM 123H K/L	32.00	30.00	32.00		210.00	42.00
23	22	CCMTR 12-200M45 MM-200	33.00	31.00	33.00		220.00	43.00
sheet2

result in OUT sheet

TB.xlsm
	A	B	C	D
1	S.N	ITEM	04/12/2023	05/01/2024
2	1	BTR-100***8 RRT-DE34230	140.00	35.00
3	2	BTR-100***8 RRT-DE34231	150.00	36.00
4	3	BTR-100***8 RRT-DE34232	160.00	37.00
5	4	BTR-100***8 RRT-DE34233		38.00
6	5	BTR-100***8 RRT-DE34234		39.00
7	6	CCMTR 12-200M45 MM 123H K/L		42.00
8	7	CCMTR 12-200M45 MM-200		43.00
9	8	CCTR 12-200M45 MM 123H K/L	20.00	23.00
10	9	CTR 12-200M45 MM 123H K/L	10.00	22.00
11	10	JKLLL2333 JK/800	210.00
12	11	RTTTM899 HJ80 12/30	220.00
13	12	VMTR 1200S45 MN 123	200.00	41.00
14	13	VSRT 258000 MJ L/66	80.00
15	14	TR 200M45MM LK H K/L	30.00	24.00
16	15	TR 1425/148V MN 123H K/L	60.00	27.00
17	16	TR 200M45 MM 123H K/L SS	40.00	28.00
18	17	TR 2.5M100**123H K/L	90.00	30.00
19	18	TR 2.5M100**123H K/LM	190.00	40.00
20	19	TR 1200M45MM LK H K/L	130.00	34.00
21	20	TTRR 1200S45 MN 123	120.00	33.00
22	21	TTRR 1200S45 MN 123	120.00	33.00
23	22	TRMN 22.5M100* 123H K/L	100.00	31.00
24	23	TTRM 12200S45 MN 1234	110.00	32.00
OUT

thanks