Excel allows you quite a lot of freedom to customize your user experience via the use of macros. This tutorial will show you how to create and name worksheets using an existing list via a macro.

You can enable macros in Excel using the Trust Center or enable a specific macro from the security warning at the top of a spreadsheet.