VBA copying file from notepad to excel sheet

[kinashinakta]

Hi! Im having a hard time compiling the data manually. Can you help me? I want to copy all the data in a notepad(i mean all that is in the notepad), then paste in an excel sheet, close the notepad, then proceed to the next notepad in the selected folder, then open the notepad(the next notepad in line), and copy and paste it in the same excel sheet but in the next column. The data in the notepad should be 2 columns wide. Thank you for your help. Thanks!