Sum multi-columns (weeks) in worksheet to single month column in different worksheet

[bacajohnson]

1. I have a worksheet (A) that takes input from another worksheet, start date, scope, number resources, and calculates how many weeks it needs to apply for that project. It also places the number of resources for different phases of the project such as if 5 is the total number of resources then cuts that number in half and applies it to a different task than the main task. Such as develop software = 5 resources but test software = 2.5 resources. So weeks 1 – 4 is 5 resources and weeks 6-8 is 2.5 resources as an example. There are several project running so in any column the resource numbers fluctuate up and down depending on the phase(week) each project is running.

2. I have a worksheet (B) that has a column for each month and year (Jan-14,Feb-14…Dec-14) that I want to summarize from sheet (A).

3. I want to update the columns from sheet (A) that is dynamic with the resources (Associated with tasks, but don’t want the tasks copied just resource numbers) and could start in any month.

4. Sheet A each month has multiple columns as they are based on week. The month consists of 3 to 4 weeks and must sum up each weeks resource in the month.

Worksheet A
		  4/24/14	5/1/14	5/7/14	5/14/14	6/1/14	6/7/14	…	12/31/14
Pro1	Incremental 	5	9	8	6	9	6	…	8
Proj1	ReAllocated 	2	0	7	5	5	5	…	6
Proj2	Incremental 	7	9	15	11	14	11	…	14
Proj2	ReAllocated 	2	4	6	4	9	4	…	2

Worksheet B
	    Jan-14	Feb-15	Mar-14	Apr-14	May-14	Jun-14	…	Dec-14
Incremental 	0	0	0	13	58	40		22
ReAllocated 	0	0	0	4	27	23		8
Total         	0	0	0	17	85	63		30

Your help would be greatly appreciated. Thank You.