Macros

Sheet Index  Instantly set up a worksheet index with hyperlinks to all the sheets.

Concatenate Range  Combines the values from the selected range of cells as a single string of text, and saves this to the clipboard ready for you to paste.

Excel Functions and Formulas

Simple drop down lists with Data Validation

Dynamic drop down lists with Data Validation  Combining data validation with INDEX and OFFSET formulas to create dynamic drop down lists that update according to the selection in the main field/column