combine excel workbook into one workbook

[civram1982]

hi can anyone help me to figure out my problem is i have so many excel workbook( ex. workbook 1, workbook 2, workbook 3, etc.. and this workbook consist of different worksheet) what im trying to do is combining all this workbook including the worksheet so that i can generate a report and print it all at once because im doing this manually by printing the worksheet one by one.

hope some can help me.. thanks in advance!

[Pepe Le Mokko]

Try this add-in. Works great and completely safe

[civram1982]

thank you and its working!