This is a great “Summary Page” technique. All of your sheets must be laid out in a consistent layout. The following SUM formula will summarise the data from all sheets onto a summary sheet.
=SUM(Sheet1:Sheet3!C5). This will add the contents of cell C5 on all sheets in the range, in this case Sheet1 to Sheet3.

This is a powerful technique and here is a tip to make it easier.
Set up your sheets in the normal way..

1) Insert a new sheet to the left of your sheets and rename it START;
2) Insert another new sheet at the right of your sheets and rename it END;
3) Use this formula: =SUM(Start:End!C5)

You should leave the START and END sheets blank. I would advise that you do not hide these sheets if you are sharing the Excel file with others

You can now add or remove sheets from this range as you need to.

Whenever you insert a new sheet tab into this workbook it will be added between the START and END tabs and will be automatically included in your summary sheet formulas.

I have just formatted the borders on an area. Now I want to redo the formatting on another area. So I highlight the area I want to repeat the formatting and then press F4.

F4 repeats the last command in Excel. This applies to most actions in Excel. It will not apply to macros.

Dragging and dropping Excel cells is the same as cut and paste (not copy)

An easy way to move a group of cells is to simply drag and drop them to a new location. To do this, simply select the group of cells by dragging your mouse across them and grab the cells when the mouse turns to an arrow and drop it into its new location.