See Ron de Bruin's site

http://www.rondebruin.nl/tips.htm

Browse through the section on Copy/Paste/Merge examples


Gord Dibben MS Excel MVP

On Tue, 20 Mar 2007 13:06:08 -0700, toneman
wrote:

Excel 2002
I have several related files that need to be in 1 workbook. Is there an
easier way than adding new worksheets, copy/paste the other workbooks and
renaming each new worksheet? This seems to be a repetative task that is right
up Excels alley. Anyone??