I would like to request Experts help create a VBA code to extract data from .txt file (source) into DailyData workbook according to the header. I have copied a sample data in DailyData workbook for Experts perusal. I have copied the source (.txt) files in a D folder (D:\data) and the code should be able to loop copy the files without overwriting the old data. Hope Experts could help me create this feature. Attached the workbook and the data (source) file for Experts perusal.