How to combine several drawings in to one multi-sheet drawing file.

It is possible by just copying and pasting sheets from one drawing file to another, but I need to do this for hundrets of files. Is it possible to use an macro or something for this?