Using VBA scripts to Combine multiple sheets from multiple workbooks to a single workbook of multiple worksheets

[Mamom]

Hi Everyone,


My requirement is,
I have multiple Excel Files (Mathe, Bio, Eng, ...) with multiple sheets (cover, group01, grou02, group3,...).

I want to create a master workbook (Master) with one sheet (Mathe, Bio, Eng, ...) for every workbook. In the master workbook.sheet(mathe) shall be the combined data from Workbokk(Mathe) and sheets (group()) and sheet cover or others.
From the group-sheets i need the name of the workbook, coloumn (A,b, C, E, H).

Hope you can help me.

Thanks


workbook(Mathe).sheet(group01)

Group_01	Klasse	Mathematik		Group	Gruppe_01_Mathe_WiSe1516
	Kurztitel	Mathe		Kurztitel	Gruppe01
				Sum
				9
ID	Dozent	Kurs		Hours	Date	Hour	exam
1	Sebastian	Algebra A		3			1
2	Sebastian	Algebra A		3			1
3	Ulrich	Geo A		3			1
4	Ulrich	Geo A					1
5
6

<tbody>
</tbody>

workbook(Mathe).sheet(group02)

Group_02	Klasse	Mathematik		Group	Gruppe_02_Mathe_WiSe1516
	Kurztitel	Mathe		Kurztitel	Gruppe02
				Sum
				10
ID	Dozent	Kurs		Hours	Date	Begin	exam
1		Algebra A		4		08:00	1
2	Sebastian	Algebra A		3		14:00	1
3	Ulrich	Geo A		3		14:00	1
4
5

<tbody>
</tbody>

workbook(Master).sheet(Mathe)

	Klasse	Mathematik
	Kurztitel	Mathe		Kurztitel	Gruppe02
Group_01	Gruppe_01_Mathe_WiSe1516
		ID	Dozent	Kurs	hours	exam
		1	Sebastian	Algebra A	3	1
		2	Sebastian	Algebra A	3	1
		3	Ulrich	GeoA	3	1
		4	Ulrich	Geo A		1

<tbody>
</tbody>

Group_02	Gruppe_02_Mathe_WiSe1516
		ID	Dozent	Kurs	hours	exam
		1	Sebastian	Algebra A	3	1
		2	Sebastian	Algebra A	3	1

<tbody>
</tbody>

 

[Mamom]

Any help please.

Thanks