Not difficult - Consolidation of sheets

[mickeystanford_alumni]

Hi everyone,
Hope you are having a good day.
I am facing an issue as I am not a vba expert with my coding when trying to tell excel to do the below:

I have 2 sheets that I want to merge on a weekly basis: Table 1 and Table 2.
The format is simple as both tables have the same headers.

What I want excel to tell is:
1. Copy all rows from table 1 and table 2 into a new sheet.
2. If "column A" from table 1 and table 2 match, (e.g. as below CCCC), then ONLY paste the row from table 2 (as it is more reliable for me).
3. As I will be doing this on a weekly basis, the week after I would just like to paste the new information below my tables 1 and 2, and then update the Matrix accordingly. I believe the coding for the first 2 points will take that into account (just in case).
4. For this 3rd point, an issue I might be facing is that maybe Product FFFF which today it was reported to have sales in Month APR, next week, I receive information than it is not APR but MAY. Then in that case, I would like to keep the MAY and delete the APR. Then, to keep the newest...this might be tricky...if any ideas then that would be a killer.

Thank you so much to everyone who could help me.
TABLE 1 TABLE 2

PRODUCT	SALES	MONTH		PRODUCT	SALES	MONTH
AAAA	1,000	APR		FFFF	50	APR
BBBB	1,000	APR		GGGG	50	APR
CCCC	1,000	APR		CCCC	2,000	APR
DDDD	1,000	APR

CONSOLIDATED

PRODUCT	SALES	MONTH
AAAA	1,000	APR
BBBB	1,000	APR
CCCC	2,000	APR
FFFF	50	APR
GGGG	50	APR

 

[Zubair]

Hi, I have a similar kind which is showing below but through simple vlookup formula not VBA.
May be this may help you.

Mr. Excel.xlsm
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z	AA
1				Volume				Sales				Cost				Profit				Product	Area	Month	Volume	Sales	Cost	Profit
2	Primary	Product	Area	Jan	Feb	Mar		Jan	Feb	Mar		Jan	Feb	Mar		Jan	Feb	Mar
3	ABLACK	A	BLACK	200	300	151		19,000	28,500	14,345		2,500	7,500	3,775		16,500	21,000	10,570		A	BLACK	Jan	200	19,000	2,500	16,500
4	BBLACK	B	BLACK	220	315	171		20,900	29,925	16,245		3,000	7,875	4,275		17,900	22,050	11,970		B	BLACK	Jan	220	20,900	3,000	17,900
5	CRED	C	RED	240	330	191		22,800	31,350	18,145		3,500	8,250	4,775		19,300	23,100	13,370		C	RED	Jan	240	22,800	3,500	19,300
6	EGREEN	E	GREEN	260	345	211		24,700	32,775	20,045		4,000	8,625	5,275		20,700	24,150	14,770		E	GREEN	Jan	260	24,700	4,000	20,700
7	DGREEN	D	GREEN	280	360	231		26,600	34,200	21,945		4,500	9,000	5,775		22,100	25,200	16,170		D	GREEN	Jan	280	26,600	4,500	22,100
8	ABLUE	A	BLUE	300	375	251		28,500	35,625	23,845		5,000	9,375	6,275		23,500	26,250	17,570		A	BLUE	Jan	300	28,500	5,000	23,500
9	AGREEN	A	GREEN	320	390	271		30,400	37,050	25,745		5,500	9,750	6,775		24,900	27,300	18,970		A	GREEN	Jan	320	30,400	5,500	24,900
10		Total		1,820	2,415	1,477		172,900	229,425	140,315		28,000	60,375	36,925		144,900	169,050	103,390		A	BLACK	Feb	300	28,500	7,500	21,000
11																		417,340		B	BLACK	Feb	315	29,925	7,875	22,050
12																				C	RED	Feb	330	31,350	8,250	23,100
13																				E	GREEN	Feb	345	32,775	8,625	24,150
14																				D	GREEN	Feb	360	34,200	9,000	25,200
15																				A	BLUE	Feb	375	35,625	9,375	26,250
16																				A	GREEN	Feb	390	37,050	9,750	27,300
17																				A	BLACK	Mar	151	14,345	3,775	10,570
18																				B	BLACK	Mar	171	16,245	4,275	11,970
19																				C	RED	Mar	191	18,145	4,775	13,370
20																				E	GREEN	Mar	211	20,045	5,275	14,770
21																				D	GREEN	Mar	231	21,945	5,775	16,170
22																				A	BLUE	Mar	251	23,845	6,275	17,570
23																				A	GREEN	Mar	271	25,745	6,775	18,970
24																										417,340
Horizontal to vertical

Cell Formulas
Range	Formula
P3:R9	P3	=+H3-L3
L10:N10,H10:J10,D10:F10,P10:R10	P10	=SUM(P3:P9)
W3:W23	W3	=VLOOKUP(($T3&$U3),$A$3:$R$10,IF($V3="Jan",4,IF($V3="Feb",5,6)),FALSE)
X3:X23	X3	=VLOOKUP(($T3&$U3),$A$3:$R$10,IF($V3="Jan",8,IF($V3="Feb",9,10)),FALSE)
Y3:Y23	Y3	=VLOOKUP(($T3&$U3),$A$3:$R$10,IF($V3="Jan",12,IF($V3="Feb",13,14)),FALSE)
A3:A9	A3	=B3&C3
R11	R11	=+R10+P10+Q10
Z3:Z23	Z3	=VLOOKUP(($T3&$U3),$A$3:$R$10,IF($V3="Jan",16,IF($V3="Feb",17,18)),FALSE)
Z24	Z24	=SUM(Z3:Z23)

 

[mickeystanford_alumni]

Hi, I have a similar kind which is showing below but through simple vlookup formula not VBA.
May be this may help you.

Hi, thanks a lot. I will give it a try. Appreciate it.