Not sure how to ask this but I am trying to set up a tracking sheet that will automatically pull info from a master sheet. I would like to send out a form from for someone to fill out and all they would need to do is put in the job # into the form, and on the track sheet it will automatically fill in the rest of the project info from the master projects sheet; Names, address, phone numbers etc. There could be hundreds of job number and address, so I am trying to find the best way to do this.
