Text to Column, Vlookup, External Data Problem

My excel vlookup in sheet "NEW", in column D is not reading the lookup value in that sheet from coulmn A. I can fix it by making the column array from "Sheet1", column A by using text to column, delimited, next, check space, then finish, but it asks me "Do you want to replace the contents of the destination cells?", if I click ok, it deletes column b,c,d in "Sheet1". Sheet 1 is pulled from an access query. How can I get the vlookup to work? File attached.