move the first part to last part for the same cell into column across sheets

[KalilMe]

hello
I need macro to move the first part to last part for each cell into column B across sheets

Microsoft Excel (1).xlsx
	A	B	C	D
1	ITEM	BR	SALE	RET
2	1	VEG TOMATO SS	12	-
3	2	VEG TOMATO AA	12	12
4	3	FR BANANA TT	200	10
5	4	FR APPLE LL	100	20
6	5	FR PEAR NN	10	-
7	6	FR BANANA QQ	20	-
FRUI

Microsoft Excel (1).xlsx
	A	B	C	D
1	ITEM	BR	SALE	RET
2	1	VEG TOMATO SS	20	-
3	2	VEG TOMATO AA	22	12
4	3	FR BANANA TT	12	10
5	4	FR APPLE LL	12	2
6	5	FR BANANA QQ	12	-
VEGI

Microsoft Excel (1).xlsx
	A	B	C	D	E	F	G
1	ITEM	BR	TY	OR	SALE	RET	BALANCE
2	1	FR BANANA	T001	TT	252	25	227
3	2	FR APPLE	T002	LL	162	42	120
4	3	FR PEAR	T003	NN	15	3	12
5	4	FR BANANA	T004	QQ	42		42
6	5	FR TOMATO	T005	SS	20		20
7	6	FR TOMATO	T006	AA	42	12	30
8	7	FR ONION	T007	AA1			0
9	8	FR ONION	T008	AA2			0
10	9	FR ONION	T009	AA3			0
SFD

Cell Formulas
Range	Formula
G2:G10	G2	=E2-F2

the result should be

Microsoft Excel (1).xlsx
	A	B	C	D
1	ITEM	BR	SALE	RET
2	1	TOMATO SS VEG	12	-
3	2	TOMATO AA VEG	12	12
4	3	BANANA TT FR	200	10
5	4	APPLE LL FR	100	20
6	5	PEAR NN FR	10	-
7	6	BANANA QQ FR	20	-
FRUI

Microsoft Excel (1).xlsx
	A	B	C	D
1	ITEM	BR	SALE	RET
2	1	TOMATO SS VEG	20	-
3	2	TOMATO AA VEG	22	12
4	3	BANANA TT FR	12	10
5	4	APPLE LL FR	12	2
6	5	BANANA QQ FR	12	-
VEGI

Microsoft Excel (1).xlsx
	A	B	C	D	E	F	G
1	ITEM	BR	TY	OR	SALE	RET	BALANCE
2	1	BANANA FR	T001	TT	252	25	227
3	2	APPLE FR	T002	LL	162	42	120
4	3	PEAR FR	T003	NN	15	3	12
5	4	BANANA FR	T004	QQ	42		42
6	5	TOMATO FR	T005	SS	20		20
7	6	TOMATO FR	T006	AA	42	12	30
8	7	ONION FR	T007	AA1			0
9	8	ONION FR	T008	AA2			0
10	9	ONION FR	T009	AA3			0
SFD

Cell Formulas
Range	Formula
G2:G10	G2	=E2-F2

when move to last part should create one space before it and every time i will create more sheets with the same structure and even change or add new data .

 

[KalilMe]

you must correct them yourself

forgive me ! I do my best . I don't want to disturb you .?
it takes from much time to test it despite of the macro is short , also I use another macro to remove the spaces instead of using manually
now your code works perfectly .
much appreciated for your help

 

[DanteAmor]

also I use another macro to remove the spaces ...
now your code works perfectly .

I'm glad to hear that. It was a pleasure to help you. Thanks for the feedback.