Step 1: Organize the Workbooks You Are Going to Combine Before you begin combining Microsoft Excel files into one worksheet, there are some important steps to take.

A complex Excel 2007 workbook could require multiple sheets. By default, Microsoft provides three sheets on each workbook, but you can add as many as you need.