copy specific column from workbook to another after match the brand

[MKLAQ]

hello
I have report this is every month then it should copy from workbook to another based on column net it should match the column b,c,d from target file with the same column b,c,d in file destination then copy the column net and make the header is month Jan , Feb. ... as in my picture after finish the year and enter in a new year then should begin again Jan ,feb ,,, and so on it should every mont copy to the next column in destination file

file 1

ITEM	BRAND	TYPE	MANFACURE	SELLES	RETURNS	NET
1	CC-RR1	LG	CHI	20	5	15
2	CC-RR2	TSH	THI	4	3	1
3	CC-RR3	SMS	KORE	130	2	128
4	CC-RR4	SON	INDO	10	8	2
5	CC-RR5	LG	INDO	32	12	20
6	CC-RR6	TSH	THI	47	12	35
7	CC-RR7	SMS	JAP	8	4	4

result file

ITEM	BRAND	TYPE	MANFACURE	JAN	FEB	MAR
1	CC-RR1	LG	CHI	15	20	3
2	CC-RR2	TSH	THI	1	22	12
3	CC-RR3	SMS	KORE	128	23	2
4	CC-RR4	SON	INDO	2	6	3
5	CC-RR5	LG	INDO	20	8	44
6	CC-RR6	TSH	THI	35	9	9
7	CC-RR7	SMS	JAP	4	4	7

 

[MKLAQ]

any helps guys?

 

[Fluff]

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at: copy data from multiple sheets to master sheet and insert column to get value
If you have posted the question at more places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.

 

[MKLAQ]

sorry Fluff , but I think slight different here I ask from file to file but in another is from sheet to another
I no know that the standard which specify the same post , any way if you consider the same thing
here is the link
copy data from multiple sheets to master sheet and insert column to get value

 

[MKLAQ]

guys it's solved , but from multiple sheets to master not workbook to another as what I request here