Import Multiple txt files

[kindlysinful]

Here is what I would like to be able to do;
Using excel I want to be able to import certain data fields, from certain text files, inside a certain folder, into certain cells on an ongoing updated spreadsheet, adding rows as I go. There maybe anywhere from two to 100 text files in the folder at any time. Let’s say my folder is on the desktop of “C” drive and named, “Import This Data”. My excel spreadsheet is titled “Imported Data”.
Example of my spreadsheet;



A
B
C
D
E
F
G
H
I
J
K
L


4
Part#
LOT#
Lat#
Status
Date Tested
Another Date
PR1-
SAM#1
PR1-SAM#2
PR1- SAM#3
PR2-SAM#1
PR2-SAM#2
PR2-SAM#3


5
999999X
88888888
L999999

04/12/2018

13724.365
14577.026
13405.151

6168.254
8098.348
6358.175


6
















The text file name would be changing but have this in common at the end of the name, “_Summ”.
Here is an example of what the text file looks like when imported into excel;





A
B
C
D
E
F
G
H
I



1



Identity Line 1





YYYYYYYYYYY













2


Identity Line 2





XXXXXXXXXX













3


Production L/N:





8888888888













4


LAT Number:





L999999999













5


(PN):





999999X













6


Lot Description





xyz













7




Date Tested:










Thu Apr 12, 2018 08:00 AM
















8


Operator ID#





7777













9


# Samples



B










10


Visual Insp Msg














11


Sample Number (S/N):





Test Type:





Test Temperature (C):





TTTTT





BWRRR





BWBU





SOR





Peak Pressure 1





Peak Pressure 2






12


1





B



X
X
X
X
X
13724.365
6168.254



13


2



B
X
X
X
X
X
14577.026
8098.348



14


3



B
X
X
X
X
X
13405.151
6358.175