Splittnig Sheets and budget tracker

[22strider]

Hello Friends
Could you please help me writing code for the following? I am using Excel 2007.
I have an input sheet as shown in the table1. Table 1 is for entering details for the invoices. As shown in the sample data, there are different types of work orders (Column D). Each expense is allocated to an account code (Column C).
This project has 2 parts.
Part 1
I am trying to write a code so that on press of a button the input data gets copied into separate spread sheets having sheet names same as the “Work Order Type”.
Please notice Tables 2, 3 and 4 showing intended output with sheet names same as the work order type.
Part 2
Based on the account code (Column C) for each entry and the month of the invoice date (Column J) the value under Total Invoice Amount (Column I) needs to be transferred to the sheet “Budget Tracker” as shown in Table 5. The amount allocated to each account is recorded for each month in the Budget Tracker.

As you can notice that the column headings are not in the row1. They are in row 8 leaving space for some static information regarding the project. So that info should not get changed.
And some fields have data validation (e.g. Account code) for maintaining data integrity. Some fields are calculated fields (e.g. Tax, Invoice total etc.).

Thanks for your help

Table 1

Excel 2007
	A	B	C	D	E	F	G	H	I	J	K
1	Company Name
2
3	Project Information Etc.
4
5
6
7
8	ORDER #	Supplier	Account Code	Work Order Type	Material Cost	Labour Cost	Total Amt before Tax	Tax (12%)	Total Actual Invoice	Invoice Date	Invoice #
9	123	ABC Ltd	9876	Major Repair	$50.00	150.00	200.00	24.00	224.00	4/1/13	4567
10	124	XYZ Ltd	7896	Minor Repair	$75.00	200.00	275.00	33.00	308.00	4/1/13	6789
11	125	LMN Ltd	3456	Maintenance Contract	$100.00	300.00	400.00	48.00	448.00	04/22/13	4567
InputSheet

Cell Formulas
Range	Formula
G9	=F9+E9
G10	=F10+E10
G11	=F11+E11
H9	=G9*12/100
H10	=G10*12/100
H11	=G11*12/100
I9	=G9+H9
I10	=G10+H10
I11	=G11+H11

Table2

Excel 2007
	A	B	C	D	E	F	G	H	I	J	K
1	Company Name
2
3	Project Information Etc.
4
5
6
7
8	ORDER #	Supplier	Account Code	Work Order Type	Material Cost	Labour Cost	Total Amt before Tax	Tax (12%)	Total Actual Invoice	Invoice Date	Invoice #
9	123	ABC Ltd	9876	Major Repair	$50.00	150.00	200.00	24.00	224.00	4/1/13	4567
10
Major Repair

Cell Formulas
Range	Formula
G9	=F9+E9
H9	=G9*12/100
I9	=G9+H9

Table 3

Excel 2007
	A	B	C	D	E	F	G	H	I	J	K
1	Company Name
2
3	Project Information Etc.
4
5
6
7
8	ORDER #	Supplier	Account Code	Work Order Type	Material Cost	Labour Cost	Total Amt before Tax	Tax (12%)	Total Actual Invoice	Invoice Date	Invoice #
9	124	XYZ Ltd	7896	Minor Repair	$75.00	200.00	275.00	33.00	308.00	4/1/13	6789
Minor Repair

Cell Formulas
Range	Formula
G9	=F9+E9
H9	=G9*12/100
I9	=G9+H9

Table 4

Excel 2007
	A	B	C	D	E	F	G	H	I	J	K
1	Company Name
2
3	Project Information Etc.
4
5
6
7
8	ORDER #	Supplier	Account Code	Work Order Type	Material Cost	Labour Cost	Total Amt before Tax	Tax (12%)	Total Actual Invoice	Invoice Date	Invoice #
9	125	LMN Ltd	3456	Maintenance Contract	$100.00	300.00	400.00	48.00	448.00	04/22/13	4567
Maintenance Contract

Cell Formulas
Range	Formula
G9	=F9+E9
H9	=G9*12/100
I9	=G9+H9

Table 5

Excel 2007
	A	B	D	E	F	G	H	I	J	K	L	M	N	O
1	PROJECT:
2	Date:	April 22, 2013
3	Months:
4
5	Account Code		Actual Expenses
6			April	May	June	July	August	September	October	November	December	January	February	March
7	9876		224.00
8	7896		308.00
9	3456		448.00
Budget tracker

Cell Formulas
Range	Formula
B2	=TODAY()

 

[22strider]

Bump