Microsoft Excel offers two ways to link sheets in a workbook: hyperlinks and macros. Hyperlinks use the program's ribbon controls, while macros use Visual Basic code.

When in an Excel sheet, click the Developer tab, click Macros in the Code group, choose the procedure in the resulting dialog shown in Figure A, and then click Run. Figure A.

When you add an worksheet, Excel positions it between the currently selected sheet and the previous sheet. Regardless of how careful you are adding new sheets, you might want to rearrange them.