Create a macro to convert multiple .txt file and place all data from text to .xls file

1. Convert multiple .txt files in a folder
2. Delimit the .txt files so that there are headers in each column
3. Format for date (1st column) should be in DD-MM-YY format
4. Place all data from .txt files into 1 .xls file
5. Scan through the data in .xls file
6. Ensure all data are unique (ie. no repeated data in each row)