formula

[pccBC]

Hi!
I'm trying to enter a formula on a master sheet that would take information from 3 workbooks and summarize the data by date, and task.
Here is data for 12/1/2017, and the master sheet is below.
Does anyone have any ideas?
Thank ;you

West 2017:	Workbook 1
Date	Task	Time
12/1/2017	OnSite	0.50
12/1/2017	Training	0.10
12/1/2017	Travel	0.05
12/1/2017	ManagerMtg	0.05
12/1/2017	Travel	0.05
12/1/2017	Telephone	0.30
North 2017:	Workbook 2
Date	Task	Time
12/1/2017	ManagerMtg	0.50
12/1/2017	Training	0.10
12/1/2017	Travel	0.05
12/1/2017	Telephone	0.05
12/1/2017	OnSite	0.05
12/1/2017	Telephone	0.30
South 2017:	Workbook 3
Date	Task	Time
12/1/2017	Telephone	0.50
12/1/2017	Training	0.10
12/1/2017	Travel	0.20
12/1/2017	OnSite	0.05
12/1/2017	Travel	0.30
12/1/2017	Telephone	0.30
Looking for a formula that would pull the data for 12/1/2017 and sum the tasks, ex: Training = 0.30, Travel = 0.65 Total TASK OnSite Training Travel ManagerMtg Telephone 12/1/2017 12/2/2017 12/3/2017 12/4/2017 <tbody> </tbody><colgroup><col><col><col><col><col><col></colgroup>

<tbody>
</tbody><colgroup><col><col><col><col span="6"></colgroup>

 

[arthurbr]

Perhaps have a look at http://www.contextures.com/xlPivot08.html