Data compiling from sheet to sheet, transfer and sorting of information to another worksht

I am trying to build a unique (?) invoicing system for my friend. The object is to list on one sheet the Date of Work, Job Name, Work Done, Hours for multiple jobs (Ward, Bowman, Reuters, etc). Then it needs to take this info to sheet 2 and compile all of each jobs (i.e. - everything Ward) hours together, multiply this number by x (this could be listed on another sheet in one cell, basically a hidden hourly rate i.e. - $30/hr), and list on one line (Ward $765). I will attach a copy of my spread sheets and put a pic you can see in my post. The number used (Ward = 1) was to set an identifier to a job for maybe an easier reference and way to find and compile jobs but is not neccesary (I was trying to help myself build this but this is outside my current experience/ability...that's why I'm here). Here are pics and the spreadsheet I started.

Tony5 pic 2.JPG
Tony5 pic 1.JPG
Tony5.xls

I sure appreciate any help you guys can give!

Steve

Got it! Even worked it out before I looked at the updated file. Thanks! Is there a way to bring the Job Name items from sheet 1 (JCA) to sheet 2 (BI) to make the list and then associate the SUMPRODUCT to its respective Job? If I have 10 Wades I need it to list "Wade" once on sheet 2 and then the SUMPRODUCT for Wade placed in a column to the right. I need it to do this for all identified different jobs on sheet 1. Also....I don't have 365, but he does...Does SUMPRODUCT work on that version/platform too?

The formula I used looks like this (from my current worksheet):

=SUMPRODUCT(--('Job Cost Analysis'!B18:'Job Cost Analysis'!B67="Ward / Suggs"),'Job Cost Analysis'!K18:'Job Cost Analysis'!K67)

to get my number but how to associate and move the name over...I suppose it will be an "IF/THEN" thing...just cant see it clearly in my head.