VBA code map values from pivot to excel table

[Wafee]

Hi, can somone help me with below requirement.

I have a pivot table as below.

Book2.xlsx
	A	B	C
3	Senior Manager	Manager	Grand Total
4	Hari		4863.99
5	Hari	BAESSLER, CHRISTINA	2719.49
6	Hari	CASO, ANDREW T	76
7	Hari	GREGORY, LISA M	709
8	Hari	JOBERT, SEBASTIEN	635
9	Hari	KERCHER, TODD E	40
10	Hari	PAONE, KELLY M	246
11	Hari	REPER, LAURA L	358.5
12	Hari	VENKATRAMAN, SRINIVAS	80
13	Sam		2103.72
14	Sam	NAIR, GIRISH	1143.72
15	Sam	SARKAR, ASHIS	720
16	Sam	(blank)	240
17	Murat		2410.25
18	Murat	FUJINAMI, GARY G	223
19	Murat	KRIER, RYAN	210.5
20	Murat	PAFF, MARK D	80
21	Murat	SCHANEL, BARBARA J	524
22	Murat	SHARMA, RAJU	70
23	Murat	TANUKU, NAGESWARA RAO	900
24	Murat	(blank)	402.75
25	Grand Total		9377.96
Sheet3

and blow as my output sheet.

Book2.xlsx
	A	B	C	D	E	F	G
2	Senior Manager	Manager
3	Sam		4548.83	6955	3494	1863.72
4	Sam	NAIR, GIRISH	1353.5	2141.5	2829.5	1143.72
5	Sam	SARKAR, ASHIS	1882.83	1842	584.5	720
6	Hari		4837.54	5674.68	3484.94	4863.99
7	Hari	BAESSLER, CHRISTINA	1902.04	2199.68	1883.94	2719.49
8	Hari	CASO, ANDREW T	283	340	40	76
9	Hari	GREGORY, LISA M	1116.5	290	734	709
10	Hari	JOBERT, SEBASTIEN	820	1363	170	635
11	Hari	REPER, LAURA L	474	716	64	358.5
12	Hari	PAONE, KELLY M	120	216	421	246
13	Hari	KERCHER, TODD E	42	294	40	40
14	Hari	VENKATRAMAN, SRINIVAS	NA	NA	NA	80
15	Hari	(blank)	80	256	132	NA
16	Murat		4370.67	5155.4	1762.33	2410.25
17	Murat	FUJINAMI, GARY G	205	552	174	223
18	Murat	KRIER, RYAN	439	394.4	120	210.5
19	Murat	PAFF, MARK D	406	966.5	120	80
20	Murat	SCHANEL, BARBARA J	614	561	32	524
21	Murat	TANUKU, NAGESWARA RAO	2222	1266.5	821	900
22	Murat	KIRKWOOD, SARA M	NA	397	NA	NA
23	Murat	SHARMA, RAJU	NA	NA	NA	70
24	Murat	(blank)	484.67	1018	495.33	402.75
25	Grand Total
Sheet2

I want to pull the numbers from pivot to my output and put it in column immediately after the last column in row 3 that contains data(In this case it is column "G" and output should start from G3 ). there will be three possible combinations.

1. only senior manager
2. Senior manager and manager
3.senior manager and blanks.

Grand total column in pivot might change in with every iteration in terms of position (It might move from column "C" to "F").