VBA excel read file text in folder

VBA excel read file text in folder

I'm new in VBA, I wonder if someone can help me out, I want to read a few
text file in one folder and put it on excel sheet using VBA code. let say
I have about 100 - 200 of single line text file that contain like below
(just example) file= james.txt, contain = Mr.James phone number is
789101112, ID card:123456789 live at California file= Andy.txt contain =
Mr.Andy phone number is 789456123, ID card:45678978622331 live at Los
angeles file = and so on.. I need to get the contain file at put in excel
to became like below A B C D 1 James Mr.James 789101112 123456789 2 Andy
Mr.Andy 789456123 45678978622331 3 and so on... Can anyone help me
please...