Track info from one w/sheet onto another.
 

I have w/sheet containing various info for specific accts. It is set up as:

A B C D
1. Acct No. Loc. Date Missing Info
2. 45G US 1/1/05 Signature
3. 82H GB 1/2/05 Name Change

I want to set up a correspondance w/sheet that would scrape any accts that
have mssing info and automatically load on the correspondance w/sheet. I'm
trying to create a formula that would scan column D for accts with missing
info row by row and link on to the correspondace w/sheet by acct no. along
with loc & date.
Could someone help me with this? Thanks!