Combining 12 files into one sheet

[lennydude]

Hi there..........

I have xls files that i do on a monthly basis. One file for each month.

I have been trying to find out how to combine them into a single file.

They are monthly sales, and i would like to keep 1 for each month and 1 for the year which has all 12 months with each month as a separate "workbook".

Thanks for any help.............

Lenny

[FrankS]

If you like a dependet file, make a relation to the original
A1:

='[new_file.xls]Table1'!A1

Drag this formula over the hole sheet.

If you like an independet file, copy and past sheet for sheet.

[JBeaucaire]

I have several macros which may be pretty much what you need. Let's see:

Many Workbooks to 1 Sheet

Many Workbooks to Separate Sheets in 1 Workbook

The parts of the code that need to be edited are colored to draw your attention.