How to copy work sheet data one workbook to other?

[sayyedkamran]

I have a use case, in which I need to merge data from 100s of workbook to one major work book.
For this I need to copy the data from one worksheet of a workbook to the major workbook. How can I do that using the most efficient method, since the workbook will be having huge data.

[Pedroski55]

Do you mean Excel files?

Do you mean copy data from 100s of Excel files to one Excel file? That is easy! Just copy row after row after row

If that is what you mean, what are the parameters?

What should go where?

It may be helpful if you post some examples of what you want to do!

[Larz60+]

There are lots of packages that will help you to do this.
One that I have used for a long time and hasn't failed me yet is pyexcel