Combining multiple workbooks into new worksheet with smiliar columns ---VBA code

[ExcelGeek5038]

Hi
I have multiple excel workbooks which have exactly same columns (Screenshot attached) and worksheet. Only data in the rows and number of rows will be different. I need to combine these workbooks into one excel worksheet with similar column heading only combing rows.
I am attaching XLBB code for one workbook here for example.
Can anyone write VBA code for this?
thanks

2-PL-JANU-20-1045-01AX (JAN-1-PL-1).xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z	AA	AB	AC	AD	AE	AF	AG	AH	AI
1							Feature Attributes
2	Corrosion Circuit*	Piping Tag/ Line Number*	Feature Class	Feature Type*	Feature ID*	Feature Size, inches	Drawing Number	Status Indicator	Design Code	Design Code Year	Material Type	Material Specification	Material Grade	Design Pressure	Design Pressure Unit	Design Temperature	Design Temperature Unit	Allowable Stress	Allowable Stress Unit	Outer Diameter	Outer Diameter Unit	Inside Diameter	Inside Diameter Unit	Joint Factor	Corrosion Allowance, mm	Insulation Status	Schedule	NWT, mm	Piping Formula	Mechanical Allowance	Design Factor	Temperature Factor	CONC(ALARM1), mm	MAWT(ALARM2), mm	Access
3	JAN-1-PL-1	2-PL-JANU-20-1045-01AX	Test point (TP)	Reducer	F01	6 x 3	0000RO-S-DG-DG09-PI-ISO0383-001-A01				Carbon steel	A 234	Grade WPB												3			7.11					3.22	1.19
4	JAN-1-PL-1	2-PL-JANU-20-1045-01AX	Test point (TP)	Welds	F02	3	0000RO-S-DG-DG09-PI-ISO0383-001-A01				Carbon steel														3			5.49					1.8	0.63
5	JAN-1-PL-1	2-PL-JANU-20-1045-01AX	Test point (TP)	Reducer	F03	3 x 2	0000RO-S-DG-DG09-PI-ISO0383-001-A01				Carbon steel	A 234	Grade WPB												3			5.49					1.8	0.63
6	JAN-1-PL-1	2-PL-JANU-20-1045-01AX	Test point (TP)	Welds	F04	2	0000RO-S-DG-DG09-PI-ISO0383-001-A01				Carbon steel														3			5.54					1.85	0.43
7	JAN-1-PL-1	2-PL-JANU-20-1045-01AX	Test point (TP)	Elbow	F05	2	0000RO-S-DG-DG09-PI-ISO0383-001-A01				Carbon steel	A 234	Grade WPB												3			5.54					1.85	0.43
8	JAN-1-PL-1	2-PL-JANU-20-1045-01AX	Test point (TP)	Welds	F06	2	0000RO-S-DG-DG09-PI-ISO0383-001-A01				Carbon steel														3			5.54					1.85	0.43
9	JAN-1-PL-1	2-PL-JANU-20-1045-01AX	Test point (TP)	Flange	F07	2	0000RO-S-DG-DG09-PI-ISO0383-001-A01				Carbon steel	A 105													3			5.54					1.85	0.43
10	JAN-1-PL-1	2-PL-JANU-20-1045-01AX	Test point (TP)	Valve	HV-0607	2	0000RO-S-DG-DG09-PI-ISO0383-001-A01				Carbon steel	A 216	Grade WCB												3			5.54					1.85	0.43
11	JAN-1-PL-1	2-PL-JANU-20-1045-01AX	Test point (TP)	Flange	F08	2	0000RO-S-DG-DG09-PI-ISO0383-001-A01				Carbon steel	A 105													3			5.54					1.85	0.43
12	JAN-1-PL-1	2-PL-JANU-20-1045-01AX	Test point (TP)	Welds	F09	2	0000RO-S-DG-DG09-PI-ISO0383-001-A01				Carbon steel														3			5.54					1.85	0.43
13	JAN-1-PL-1	2-PL-JANU-20-1045-01AX	Test point (TP)	Pipe	F10	2	0000RO-S-DG-DG09-PI-ISO0383-001-A01				Carbon steel	A 106	Grade B												3			5.54					1.85	0.43
14	JAN-1-PL-1	2-PL-JANU-20-1045-01AX	Test point (TP)	Welds	F11	2	0000RO-S-DG-DG09-PI-ISO0383-001-A01				Carbon steel														3			5.54					1.85	0.43
15	JAN-1-PL-1	2-PL-JANU-20-1045-01AX	Test point (TP)	Flange	F12	2	0000RO-S-DG-DG09-PI-ISO0383-001-A01				Carbon steel	A 105													3			5.54					1.85	0.43
16	JAN-1-PL-1	2-PL-JANU-20-1045-01AX	Test point (TP)	Flange	F13	2	0000RO-S-DG-DG09-PI-ISO0383-001-A01				Carbon steel	A 105													3			5.54					1.85	0.43
17	JAN-1-PL-1	2-PL-JANU-20-1045-01AX	Test point (TP)	Welds	F14	2	0000RO-S-DG-DG09-PI-ISO0383-001-A01				Carbon steel														3			5.54					1.85	0.43
18	JAN-1-PL-1	2-PL-JANU-20-1045-01AX	Test point (TP)	Pipe	F15	2	0000RO-S-DG-DG09-PI-ISO0383-001-A01				Carbon steel	A 106	Grade B												3			5.54					1.85	0.43
19	JAN-1-PL-1	2-PL-JANU-20-1045-01AX	Test point (TP)	Welds	F16	2	0000RO-S-DG-DG09-PI-ISO0383-001-A01				Carbon steel														3			5.54					1.85	0.43
20	JAN-1-PL-1	2-PL-JANU-20-1045-01AX	Test point (TP)	Flange	F17	2	0000RO-S-DG-DG09-PI-ISO0383-001-A01				Carbon steel	A 105													3			5.54					1.85	0.43
21	JAN-1-PL-1	2-PL-JANU-20-1045-01AX	Test point (TP)	Valve	HV-0608	2	0000RO-S-DG-DG09-PI-ISO0383-001-A01				Carbon steel	A 216	Grade WCB												3
22	JAN-1-PL-1	2-PL-JANU-20-1045-01AX	Test point (TP)	Flange	F18	2	0000RO-S-DG-DG09-PI-ISO0383-001-A01				Carbon steel	A 105													3			5.54					1.85	0.43
23	JAN-1-PL-1	2-PL-JANU-20-1045-01AX	Test point (TP)	Welds	F19	2	0000RO-S-DG-DG09-PI-ISO0383-001-A01				Carbon steel														3			5.54					1.85	0.43
24	JAN-1-PL-1	2-PL-JANU-20-1045-01AX	Test point (TP)	Elbow	F20	2	0000RO-S-DG-DG09-PI-ISO0383-001-A01				Carbon steel	A 234	Grade WPB												3			5.54					1.85	0.43
25	JAN-1-PL-1	2-PL-JANU-20-1045-01AX	Test point (TP)	Welds	F21	2	0000RO-S-DG-DG09-PI-ISO0383-001-A01				Carbon steel														3			5.54					1.85	0.43
26	JAN-1-PL-1	2-PL-JANU-20-1045-01AX	Test point (TP)	Flange	F22	2	0000RO-S-DG-DG09-PI-ISO0383-001-A01				Carbon steel	A 105													3			5.54					1.85	0.43
27	JAN-1-PL-1	2-PL-JANU-20-1045-01AX	Test point (TP)	Flange	F23	2	0000RO-S-DG-DG09-PI-ISO0383-001-A01				Carbon steel	A 105													3			5.54					1.85	0.43
28	JAN-1-PL-1	2-PL-JANU-20-1045-01AX	Test point (TP)	Welds	F24	2	0000RO-S-DG-DG09-PI-ISO0383-001-A01				Carbon steel														3			5.54					1.85	0.43
29	JAN-1-PL-1	2-PL-JANU-20-1045-01AX	Test point (TP)	Pipe	F25	2	0000RO-S-DG-DG09-PI-ISO0383-001-A01				Carbon steel	A 106	Grade B												3			5.54					1.85	0.43
Piping Features

Cell Formulas
Range	Formula
L3:L29	L3	=IF(D3="Pipe","A 106",IF(D3="Mitred Elbow","A 106",IF(D3="Sweepolet","A 105",IF(D3="Thread","",IF(D3="Reducing Tee","A 234",IF(D3="Welds","",IF(D3="Expansion Bellow","",IF(D3="Reinforcement Pad","",IF(D3="Threaded Joint","",IF(D3="Cap","A 234",IF(D3="Elbow","A 234",IF(D3="Tee","A 234",IF(D3="Reducer","A 234",IF(D3="Weldolet","A 105",IF(D3="Flange","A 105",IF(AND(D3="Valve",F3<2),"A 105",IF(AND(D3="Valve",F3>=2),"A 216","Error")))))))))))))))))
M3:M29	M3	=IF(D3="Pipe","Grade B",IF(D3="Mitred Elbow","Grade B",IF(D3="Sweepolet","",IF(D3="Thread","",IF(D3="Reducing Tee","Grade WPB",IF(D3="Welds","",IF(D3="Expansion Bellow","",IF(D3="Reinforcement Pad","",IF(D3="Threaded Joint","",IF(D3="Cap","Grade WPB",IF(D3="Elbow","Grade WPB",IF(D3="Tee","Grade WPB",IF(D3="Reducer","Grade WPB",IF(D3="Weldolet","",IF(D3="Flange","",IF(AND(D3="Valve",F3<2),"",IF(AND(D3="Valve",F3>=2),"Grade WCB","Error")))))))))))))))))

Cells with Data Validation
Cell	Allow	Criteria
AI3:AI29	List	=access
H3:H29	List	=statusIndicators
S3:S29	List	=pressure
O3:O29	List	=pressure
Q3:Q29	List	=temp
W3:W29	List	=corrosionAllowance
U3:U29	List	=corrosionAllowance
Z3:Z29	List	=insulationStatus
D15:D29	List	=featureType
D3:D13	List	=featureType
A3:A808	List	=ccTags
B3:B808	List	=piping
C3:C1259	List	=featureClass