You can also move sheets from multiple files into a new Excel file. Open the source Excel file, and switch to the sheet you wish to copy Click on Home tab > Cells section > Format > Move or copy ...