merging worksheets

[KRK]

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

 

[Luke M]

You might want to take a look at Ron's article here:

http://msdn.microsoft.com/en-us/library/cc837974.aspx

But for only 6 sheets, it might just be easier to copy each worksheet.
You're choice.