Copying data from different sheet from different workbook

[Venus_excel]

Hi all,

Once again Im happy to share it in mrexcel because of magic people are here to help me and they have also helped
Here is my mini project and need ur help to done.
Any how Thanks in Advance.


Below is the content of the single sheet in workbook.

Sample sheet(Sheet1_Kavin)

1	A	B	C	---	T	U	V	W
2				---
3	No_1	No_2	No_3	---	No_18			3
4	1	Kavin	CSE	---	DEPT	Kumar
5	2	Suresh	ECE	---	DEPT	Ramesh

<tbody>
</tbody>

Sheet2_Kavin

1	A	B	C	---	T	U	V	W
2				---
3	No_1	No_2	No_3	---	No_18			2
4	1	Giri	EEE	---	DEPT	Raj
5	2	Nees	ECE	---	DEPT	NA

<tbody>
</tbody>

Master sheet

1	Sheet name
2	Sheet1_Kavin	1	Kavin	CSE	---	DEPT	Kumar	3
3	Sheet1_Kavin	2	Suresh	ECE	---	DEPT	Ramesh
4	Sheet2_Kavin	1	Giri	EEE	---	DEPT	Raj	2
5	Sheet2_Kavin	2	Nees	ECE	---	DEPT	NA

<tbody>
</tbody>

Hint

1. Like this all data from all sheet from all workbook should put it into a single master file in the above format.
2. Data should only pick from the following sheet (Sheet1_Kavin, Sheet2_Kavin, Sheet3_Kavin, Sheet4_Kavin, Sheet5_Kavin, Sheet6_Kavin and Sheet7_Kavin) – Totally 7 sheets
3. It should pick .xls file
4. There is more than 100 .xls file are available to process.

 

[Venus_excel]

Hi Experts,

If any one need more updates kindly please let me know.
Its very critical for me so please magic ppl work on this and give updates.
Thanks once again for ur support.

 

[Venus_excel]

Hi Experts,

Is any one is here to help me in this critical situation.