The simplest approach might be to use a macro to open each of the
source workbooks in turn and copy the worksheet into your master book.

You could do most of it by using the macro recorder.

Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup