Consolidating Workbooks content in Sheet 1 to single sheet

[rajamsc2003]

I am having several excel Master1.xls, Master2.xls with content as below

	S. No.	Solution ID	Employee ID	Categroy	Date
	1	13279-5-48P	201962	Complex	2-Jan
	2	13279-5-32P	201966	Complex	2-Jan
	3	13344-13-1TF	300780	Simple	2-Jan

<colgroup><col><col><col><col><col></colgroup><tbody>
</tbody>

Wish to consolidate all the counts in 30 Workbooks based on Employee ID. Please help me. All the excels having Master1.xlsx,......Master30.xlsx. with same column header. The variable is employee number.