Automate data entry from another workbook

Please help me, i want to automate a task in excel but i don't know how to do it since data extraction is complicated. Here's what needs to be done:   1. When i enter the JT number excel should be ...