List Item by Date on seperate sheet

OK so this may sound a bit complicated but maybe someone can help me:

I have a spreadsheet with a master set of data for all jobs worked on this year for my company. There are 2 date fields in this spreadsheet one for when the job was taken and one for when the job was installed. I have subcontractors that get paid a percentage at each date.

What I would like to do is on a second sheet create two inputs, 1 for the date of the start of a week and 1 for the date of the end of the week, when those fields are filled I would like the spreadsheet to list jobs that were taken and completed during those dates, as well as the total contract amount and percentages that the contractors are getting paid.

I have had limited success with playing with different functions such as index and match in array's

The data in my sample is fictitious, and there are a few other fields and many other formulas within it, but this information given is a sample of the kind of data I have...

What I want is a seperate sheet for each sales rep (contractor) where I put in date range it shows data like on the second sheet

Can Anyone help please!