No macros, no copy and paste
The usual ways to do this in Excel are Power Query, a VBA macro or copying each sheet by hand. Here you just upload the workbook. It works the same on Windows, Mac and Chromebooks, and the file never leaves your computer.
Sheets with different layouts
Columns do not need to be in the same order on every sheet. Matching is by header name, and a column that only exists on some sheets is kept with blanks elsewhere. If a sheet has a title above its header row, the header is detected automatically.
What is read from each cell
Values are read the way Excel shows them: formulas come through as their results, dates as YYYY-MM-DD and formatted numbers such as zip codes keep their leading zeros. Formatting, colours, charts and comments are not carried over.