Help with Query Syntax

[CJB]

Hi there

I'm trying to create a workbook to track projects and time estimates running through my company. 

Sheet 1 should act as a cover sheet - this will include a breakdown of work by project with cumulative totals for estimate and actual time columns taken from the subtasks included on sheet 2.

Sheet 2 is a breakdown of each project's sub tasks with estimates and actual timings alongside.

The columns in sheet 2 are: A=Client, B=Project Name, C=Task Description, D=Estimated Time, E=Actual Time, F=Time Remaining

Sheet 1 should have a formula that effectively pulls through the sum of column D, when column B = a specific term. (I would then change column D to be column E and so on).

Is this possible? Does this make sense?

Thanks

Charlie