How Excel creates a worksheet name in bulk

Excel creates a table name in bulk by following these steps:

To do this: for example, in the following illustration, create a table name area and click Insert-PivotTable. (Figure 1 below)

After you click OK, in the PivotTable field, drag the table name fields to the filter. (Figure 2 below)

Then click the PivotTable Tool-analysis-Options Drop-down box and select Show Report Filter page. (Figure 3 below)

When you click OK, the system automatically generates the name of the table from January to December.