Question: how do i copy multiple excel sheets into one?
Answer: Open the sheets you want to merge.
Click Home > Format > Move or Copy Sheet.
Use the dropdown menu to select (new book).
Click OK.