Here are some steps you can follow to properly merge sheets and workbooks in Excel:

1. First, open two or more sheets or workbooks that you want to work with.
2. Then, select the sheets you want to merge into one.
3. On the Home tab of the ribbon, select the ‘Move or Copy’ command.
4. In the dialog box that appears, make sure all necessary merge sheets check boxes are selected.
5. Click OK and the sheets will be merged properly.