I’m trying to create a pivot table based on filtered data.

I am trying to show the detail on each of these rows (except the blank and grand total row) & rename the sheet to the row label without double clicking each row total as the normal table has hundreds of rows.

I want to filter a pivot table named RawDataTable contained in a sheet named RawData. I want to filter the pivot table by date based on the cell value contained in the cell F1 (start date) and F2 (end date) contained in another sheet named Locked.

I have mutiple pivot table in 1 sheet, which are also linked to pivotcharts.
How can i have excel auto-fresh when i add columns / rows to my main data source?
I want to avoid changing the data source for each pivot table manually.