This article provides details on filtering blank worksheets with parameters and the lookup filter.
If you would like to use a Parameter with ranges for the Create Sheet Per Value option, it will create a blank worksheet if a value within the range has no values. To correct this, you can make a lookup filter with the values you want to use in the Create Sheet Per Value menu and then uncheck “Use Ranges” and a worksheet will be generated for each value that is selected.
