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 dept 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.