Link here

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

There is no native menu item to do this. You will need a macro - see the link that I posted.

You can do this manually, fairly easily, on a sheet by sheet basis. Depending how many sheets there are, this may, or may not, be a practical way of doing it.

First I'd create a new workbook, save it, and name it something obvious, ("Summary" perhaps?)

Have this workbook open.

Open the workbook(s) you want to combine. I'd rename the sheets in question so they each have individual, relevant, names, rather than each one being "Sheet1"

RIGHT click on the tab of the first sheet you wish to combine. On the menu that appears there is an option to "Move or Copy", and if you choose that you can select where to move/copy it to. Providing you have the "Summary" workbook open you can copy or move, (don't miss the checkbox to choose which!), the worksheet to this workbook.

If you only have a few worksheets to copy this may be practical... if you have loads of them... well only you can decide! If I've read your issue correctly you only have one to add each month so once you've started the process with the first bunch of however many, it should be a simple quick operation monthly!

(Bear in mind that there may be issues with referred formulae if the originals have formual referring to other workbooks/worksheets!! I haven't read/digested the VBA that Vog has linked to, but that might accomodate such an issue?)

With apologies if I've missed the point and this doesn't suit!

Regards,

Simsy