Hello,

I have 6 workbooks all with a single worksheet. I want to bring them
together into a single workbook with 6 worksheets. I can do it via copy &
paste, but is there a simpler way please ?

I have excel 2007

Thanks

K