Return entire row if criteria is met

[JACOBB9900]

Hello I am having trouble figuring this out. I have two worksheets. The first worksheet is a Gantt chart which shows the progress of each job and the second worksheet contains the details of that job and the operations it contains. I need to return the cells in Sheet 2 that follow each job, onto Sheet 1. The data has to start on the "Start" date as shown in the example. I put example data in Sheet 2 because this is how i have my sheet laid out. I have a code, hours and machine for each job which is concatenated in the row in front of the job. I tried to set it up as best as i could in the example. Job#1111 starts on Feb. 24th so the data is returned starting on Feb. 24. Job#2222 starts on Feb. 27 so the data is returned starting on Feb. 27 and so on. Please let me know if there is something i didn't explain correctly.

Thank you for all the help. All input is appreciated.

 

[mumps]

For clarification, you want to take the job details from sheet2 and place them in sheet1 starting at each job's start date column. Is this correct?