Automatically fill one sheet based on another

Dear Excel Forum Friends ;
I am sekhar i am from INDIA. I am working as System Admin. My office i maintain Excel Sheet in day to day work and i provide Every Job has one job number. Now i maintain Invoice also. I created Invoice format in excel . and in invoice to type consignee name, Job id, Bill of Lading No, no of Items, item Description. These all are i entering to day to day excel sheet. now i want when i put job id automatically fill corresponding cells from day to day excel sheet.Is any Idea

Please advise Me

Please take a moment to read the forum rules and then amend your thread title to something descriptive of your problem. Once you have done this please send me a PM and I will remove this request.

To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

Your title is still not right. You can try changing it to "Automatically fill one sheet based on another".