Transfer certain data entered to another sheet auto

restoreman - Mar 19, 2015 at 07:19 PM

I work for a restoration company. We often enter a list of what was done on the job during the day by employee into a spreadsheet. For example: if bob was an employee of mine he would have a page in excel named bob. Then a job project number, date, time it took, and what was done. That is all set up and done.

However we also have a job excel sheet set up the same way. For years I have been finding the job number on every employees page then copying it to the job page. I was wondering if there was a way to automatically have excel pull all the info that pertained to a job and put it on the job page. For example, Bob did job number 1 on 3-2-2015 it took 5 hrs and he removed mold. Now I want excel to take the line of data pertaining to job 1 and puts it onto the page marked job 1.

Thank you for your help.