Hi,

long time user, first time poster.

i have a pivot table that I change the data source on weekly. All the data sources are tabs in the same workbook. I'd like to be able to display the tab name that contains the data source as a cell on my pivot table so I know which table I am pivoting without having to open the options/ change data source etc.

any help here would be much appreciated.

Cheers
KC