I am very new to this forum as well As VBA too..i Have a excel and multiple work sheets like 10+ and data will imported while created.

Daily in some path a text files will be placed that having the same as work sheet name(Example text file name is ADC.txt,excel work sheet have same name).
i need to over write the data of my work sheet when i click any button that assigned to import macro based on the file name to the work sheet.

Ex:
if the path has ADC.txt ,PDC.txt,RDC.txt file when i click the import button or any button assigned to the macro , the data in the text file should be imported to the respectively to the work sheets in the excel...