Merge workbooks sheets

[Valentinas]

Helo, I have one problem.
I have 3 workbook, with same same sheets names.
Example:
Workbook1: sheet1, sheet2, sheet3
Workbook2: sheet1, sheet2, sheet3
Workbook3: sheet1, sheet2, sheet3

In the all sheet1 is same columns name, but different data.
Name, Surname, Password and etc.
Data1, Data2, Data3

Sheet1 from other workbook example:
Name, Surname, Password and etc.
Data11, Data22, Data33

Question:
How merge the Workbook1, workbook2, Workbook3 to master Workbook, ant merge sheets1 and etc. from all workbook in the Master workbook one sheet.

Finish result:
One workbook, the 3 sheet, this merge data.
Name, Surname, Password
Data1, Data2, Data3
Data11, Data22, Data33

I hope to understand :)

[Valentinas]

vbaexpress.com/kb/getarticle.php?kb_id=773 is best script, but merge all sheet in the one sheet, i want to all sheet1 merge to sheet1, all sheet2 to sheet2 ant etc :)