Validation or define problem

Hi!
I have two file! i try to use define-name to link the both file,
Basically two file
1is supplier list i have made the define of coca cola sheet of coke list and K & N list in chicken item
2 Data base i want to link all the supplier head in supplier coloumn

I spend a lot of time to solve that query.
Kindly solve my problem.
is there any idea i welcome.

CHACHA