Copy specific data from an excel template and paste in new workbook

[excel_1317]

I have around 100 excel templates in a folder from which I need to extract data from specific cells and put in a separate workbook. Is this something that can be done macro. The logic is MACRO open first template -> Copy Specific Cells -> Paste into new workbook-> Close template-> Proceed open with next template....

The cells(Summary sheet) which we need to copy are E5, D20, C43, D43, C85, D85, C87 and D87. Below is sample excel template.

Sheet2

	A	B	C	D	E	F	G	H
1	Output from Pricing Calculator v5.04
2
3	The following pricing structure was produced on:						09 January 2013
4
5	Client Name:				Sandvik Future
6	Salesperson:				Karin Kärvling-Söholt
7	Sales Region:				ROW
8
9	Client Country:			Sweden			Free Text Comments
10	Client Type:			Direct Corporate
11	Number of end clients (if Agent):			-
12
13	Annual Renewal Breakdown:
14		USD - US		45
15		USD - Non US		170
16		GBP		340
17		EUR		680
18		Invoice Currency		340
19		Other		1,020
20		Total:		2,595
21
22
23			Standard Pricing	Proposed Pricing	Variance	Existing Pricing	Variance
24					(Prop. to Std.)		(Prop. to Existing.)
25
26	PER RENEWAL:
27		Client Currency:	SEK	SEK
28
29		Fee Series:	8	N
30		Est. Currency Contribution (£):	79.18	68.26	-10.92
31
32		Basic Service Charge Currency:	GBP	GBP
33		Basic Service Charge (FX):	9.00 GBP - Code: 09	6.98 GBP - Code: N/A	(£2.02)
34
35	Pricing code will need review due to additional charges.	Invoicing:	Automatic / Quarterly	Automatic / Quarterly
36		(£):	0.00	0.00	0.00
37		Credit terms:	30 Days	60 Days
38		(£):	0.00	4.02	4.02
39		Receipts:	Store	Store
40		(£):	0.00	0.00	0.00
41
42		Total Service Charge (£):	9.00	11.00	2.00
43		Total Service Charge (Inv Curr):	99.19	121.28
44		Total Service Charge (S/C Curr):	9.00 GBP - Code: 09	11.00 GBP - Nearest Code: N/A	£2.00
45		Reduced fees flag:	YES	Yes
46		Est. Country Fee (£):	0.00	0.00	0.00
47
48		Commission arrangment:	NOT APPLICABLE	NOT APPLICABLE
49		Commission amount:	0.00	0.00
50
51
52	ANNUAL ESTIMATE:
53		Client Currency:	SEK	SEK
54
55		Fee Series:	8	N
56		Est. Currency Contribution (£):	205,476.87	177,135.23	-28,341.64
57
58		Basic Service Charge Currency:	GBP	GBP
59		Basic Service Charge:	23,355.84	18,113.75	(£5,242.09)
60
61	Pricing code will need review due to additional charges.	Invoicing:	Automatic / Quarterly	Automatic / Quarterly
62			0.00	0.00	0.00
63		Credit terms:	30 Days	60 Days
64			0.00	10,445.11	10,445.11
65		Receipts:	Store	Store
66			0.00	0.00	0.00
67
68		Total Service Charge (£):	23,355.84	28,558.86	5,203.02
69		Total Service Charge (Inv Curr):	257,399.99	314,741.47
70
71		Reduced fees flag:	YES	Yes
72		Est. Country Fee (£):	0.00	0.00	0.00
73
74		Commission arrangment:	NOT APPLICABLE	NOT APPLICABLE
75		Commission amount (£):	0.00	0.00	0.00
76
77
78	Estimated Disbursements (£):		801,353.78	801,353.78	0.00
79	Estimated Disbursements (Inv Curr):		8,831,559.76	8,831,559.76
80
81	Estimated Turnover (£):		1,050,241.18	1,027,102.57	-23,138.61
82	Estimated Turnover (Inv Curr):		11,574,497.99	11,319,491.95
83
84
85	Estimated Gross Income (£):		248,887.40	225,748.78	-23,138.61
86	Estimated Gross Income (Inv Curr):		2,742,938.22	2,487,932.19	-255,006.03
87	Gross Income/case (£)		95.91	86.99

<thead>
</thead><tbody>
</tbody>

Excel 2010





Desired result is shown in table below.
Sheet1

	A	B	C	D	E	F	G	H
1	Client Name	Volume	Total Service Charge(Standard Pricing)	Total Service Charge(Proposed Pricing)	Estimated GI(Standard Pricing)	Estimated GI(Proposed Pricing)	GI per case(Standard Pricing)	GI per case(Proposed Pricing)
2	KTS	400	109.09	121.21	1,433,934.54	1,492,558.60	296.48	308.6
3	Microsoft

<thead>
</thead><tbody>
</tbody>

Excel 2010

 

[excel_1317]

The cells which we need to copy are E5, D20, C43, C46, D46, D43, C85, D85, C87 and D87

 

[excel_1317]

Somebody please help me...

 

[excel_1317]

Excel masters plzzzz help