Auto copy data from another database
 

I have designed a worksheet named Test.xls, & want whenever put date in E7
(letter sheet) the acknowledgement no. will be copy from received sheet & in
B18 (letter sheet) date should be copy starting date inrespect of sending
date (that means letter date & sending date shoul match) as shown in letter
sheet. simultaneously in PANNOTAVBL seet also copy whose PAN No.
("PANNOTAVBL") from Received Sheet. For make your better understanding I'm
uploading a excel file (Test.xls) in following url
http://www.freefilehosting.net/download/test.xls
So, if anybody look this files & solve it for me then I shall be very
thankful to him / her.
Thanks in advance.