Before merging, ensure you have all the Excel files open. Only when they are open can the Excel merge function choose a destination. You can also move sheets from multiple files into a new Excel file.