combining multiple sheets/files as tabs into one workbook

%3CLINGO-SUB%20id%3D%22lingo-sub-2566104%22%20slang%3D%22en-US%22%3Ecombining%20multiple%20sheets%2Ffiles%20as%20tabs%20into%20one%20workbook%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2566104%22%20slang%3D%22en-US%22%3E%3CP%3EI%20often%20combine%2011%20separately%20generated%20tab%20delimited%20files%20(denoted%20as%20.xls%20but%20that's%20changeable)%20into%20a%20single%20workbook%20with%2011%20tabs.%26nbsp%3B%20I%20get%20tired%20of%20opening%20each%20of%20the%2011%20files%20separately%20and%20moving%20each%20to%20the%20combined%20workbook.%26nbsp%3B%20Is%20there%20ONE%20command%20that%20will%20do%20this%20more%20efficiently%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EUsing%20Excel%2016.46%20on%20Mac%20OS%2010.15.7%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2566104%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%20on%20Mac%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2575523%22%20slang%3D%22en-US%22%3ERe%3A%20combining%20multiple%20sheets%2Ffiles%20as%20tabs%20into%20one%20workbook%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2575523%22%20slang%3D%22en-US%22%3EWhat%20can%20I%20say%2C%20with%20Excel%20for%20Windows%20this%20is%20as%20easy%20as%20pie.%3C%2FLINGO-BODY%3E
New Contributor

I often combine 11 separately generated tab delimited files (denoted as .xls but that's changeable) into a single workbook with 11 tabs.  I get tired of opening each of the 11 files separately and moving each to the combined workbook.  Is there ONE command that will do this more efficiently?

 

Using Excel 16.46 on Mac OS 10.15.7

1 Reply
What can I say, with Excel for Windows this is as easy as pie.