Extracting data from specific rows and columns from multiple csv files

I have a series of csv files in the following format
eg file1

Experiment Name,XYZ_07/28/15,
Specimen Name,Specimen_001,
Tube Name, Control,
Record Date,7/28/2015 14:50,
$OP,XYZYZ,
GUID,abc,
Population,#Events,%Parent
All Events,10500,
P1,10071,95.9
Early Apoptosis,1113,11.1
Late Apoptosis,1091,10.8
Live,7856,78
Necrosis,11,0.1

file2

Experiment Name,ABC_07/28/15
Specimen Name,Specimen_001
Tube Name,OA_10uM
Record Date,"Jul 28, 2015 2:52:36 PM"
$OP,XYZYZ 
GUID,abc
Population,#Events,%Parent
All Events,12156,
P1,11821,97.2
Early Apoptosis,806,6.8
Late Apoptosis,901,7.6
Live,10087,85.3
Necrosis,27,0.2

I would like to extract Tube names ( 3rd row, 2nd column) and Last 4 rows {labels in column 1 only from 1st file and values in columns 3 from all files and write to to an output file.

expected output is :

Tube Name	Early Apoptosis	Late Apoptosis	Live	Necrosis
Control	11.1	10.8	78	0.1
OA_10uM	6.8	7.6	85.3	0.2

Can someone help me figure out the code ?

Thanks a ton

Confused about ending commas. Some lines end in commas and others don't: this differs between file1 and file2. Are they actually that different or are these typos?

Are there constraints on the solution, must it be bash or can one use awk or perl?

My bad sorry.
when I open these files on notepad, I only see line 8 to have the comma in the end
I don't mind any solution as long as it works.
Thanks

Could you edit your initial post to display the lines in file1 and file2 as they show in your editor?
Do not use the icode tags, copy and paste, highlight it and click in the square code icon.

ok
so I'm providing 2 new files : file3 and file4 with your suggestions
file3

Experiment Name,ABC_07/28/15
Specimen Name,Specimen_001
Tube Name,Unstained Control
Record Date,"Jul 28, 2015 2:42:33 PM"
$OP,XYZ 
GUID,abc
Population,#Events,%Parent
All Events,15282,
P1,14744,96.5
Early Apoptosis,71,0.5
Late Apoptosis,1,0.0
Live,14672,99.5
Necrosis,0,0.0

file4

Experiment Name,ABC_07/28/15
Specimen Name,Specimen_001
Tube Name,OA_10uM
Record Date,"Jul 28, 2015 2:52:36 PM"
$OP,KLM 
GUID,efg 
Population,#Events,%Parent
All Events,12156,
P1,11821,97.2
Early Apoptosis,806,6.8
Late Apoptosis,901,7.6
Live,10087,85.3
Necrosis,27,0.2

Thanks

Try

awk -F, -v HD="Tube Name,Early Apoptosis,Late Apoptosis,Live,Necrosis" '
BEGIN           {for (N=i=split (HD, T); i>0; i--) SRCH[T]
                 for (i=1; i<=N; i++) printf "%s\t", T
                 print ""
                }
FNR==1 && L     {for (i=1; i<=N; i++) printf "%s\t", PR[T]
                 print ""
                 delete PR
                }

$1 in SRCH      {PR[$1]=$NF
                 L=1
                }
END             {for (i=1; i<=N; i++) printf "%s\t", PR[T]
                 print ""
                }
'  file[12]
Tube Name       Early Apoptosis Late Apoptosis  Live    Necrosis
Unstained Control       0.5     0.0     99.5    0.0
OA_10uM 6.8     7.6     85.3    0.2

import os
from collections import deque

def parse_file(f,first=0):
	header=""
	line_3=""
	cnt=0
	q=deque([],maxlen=4)
	with open(f) as file:
		for line in file:
			line=line.replace("\n","")
			cnt+=1
			if cnt==3:
				line_3 = line
			else:
				# print(line)
				q.extend([line])
				
	items = line_3.split(",")
	if first:
		header = header+" "+items[0]
	content=items[1]
	for i in q:
		items = i.split(",")
		if first:
			header = header+" "+items[0]
		content = content+" "+items[2]
	if first:
		print(header)
	print(content)
	
file_cnt=0				
for file in os.listdir("leo"):
	file="leo/"+file
	if file_cnt==0:
		file_cnt+=1
		parse_file(file,first=1)
	else:
		parse_file(file)