How do you  combine multiple excel files into one?
 1 Select the files for consolidation. 2 On Step 2 of the wizard, select the Consolidate worksheets with the same name to one sheet radio button. 3 On the Consolidation options step choose how you prefer to paste the data. 