Amalgamate / Merge / Join

**Borske** · 08-18-2010, 10:38 AM

I have 30 seperate spreadsheets that I would like to join into one.
I want each spreadsheet to be a seperate tab.

So I want to have one document with 30 seperate tabs of different information on each tab.

I tried copying and pasting but it doesnt seem to keep the everything the way I would like it. Colors are lost and cell sizes change.

Is there anyway I can put all these seperate spreadsheets together without losing the layout / format of each sheet?

P.S: Sorry if this has been asked before. I did a search and did not find my answer.

Thank You!

**JBeaucaire** · 08-18-2010, 10:42 AM

Do you mean you have 30 separate workbooks with one sheet in each that you would like to join into one master workbook?

'WORKBOOKS INTO SHEETS
I have a macro that may be pretty close to "ready to use" for collecting data from all files in a specific folder. (and/or subfolders)

Workbooks to Sheets - PART 2

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