Need to auto fill cells based on input of a single cell.

I work for a company that is leary of technology.  We use Excel as a database instead of SQL tales.

We have one sheet that has a list of projects we subcontract on. 

We have another sheet used to schedule employees.

When I took this job, I had to copy and paste each cell from one sheet to the other because the data was in a different order. Since I took the job, I reorganized the data so now I can copy and paste the whole row at once.

Now what I want to do is type the job number into the schedule page, Column F Rows 4-100, and have the rest of the info pulled from the Project page, Column B Rows 2-1000, for that project instead of copy and paste. 

So, if I type a project # into Schedule Sheet F4, the project name populates in Schedule sheet G4 from Project Column C CellX (that corresponds to the project #). Same for Schedule Cells G6-N6 From Project Columns C-J

Thank you for your help.