Way to autocomplete entry from other sheet.

I'm wondering is it possible to get data auto-filled in one excel file from other.

Example : .
#
I have a excel file with columns like Name, Phone number , Address and pending amount which i fill whenever i get a new customer and update it when he borrows money.
Worksheet 1 (data.xlsx):
***
Name _______ Phone No.______Address _____ _______________Pending amount
Jack G. ___ +1234556 ____ 56-G,John Street,Louisiana. _______ $100
Warren F. ____ +1544659 ____ 91-K, Near Henry's, Louisiana. ________$230

***
#
Other Excel worksheet which is a bill, in which I need some extra details except the Address :
Worksheet 2 (bill.xlsx):
****
Name ____Phone No._______ Product Name _____Bill Amount ______ Pending amount___ Total
Jack G ____+1234556 ______ Hat,shoes _________ $70 ___________ $100 _________ $170

- So i want to autofill columns (Ph. No , Pending Amount) from data.xlsx to this bill.xlsx at the moment when i type Jack.. .

If Jack G. is a unique entry then you could use either VLOOKUP or INDEX/MATCH.
To get more specific help I feel that we need to see a sample Excel File (instructions in the banner with the title: "HOW TO ATTACH YOUR SAMPLE WORKBOOK").
Let us know if you have any questions.