Here’s a technique I use a lot to speed up report development.

Sheet names have to be unique, so they can’t be duplicated. This makes them great for department names or states.

This short video combines a few techniques to extract from a data set based on the sheet name.

All in less than a minute.