Morning all,

a fresh new query for you all,

I have a workbook called disputes and it has 2 pivots in, each on seperate sheets.

What i would ideally like is a macro that gets the pivot table names and places them on a new sheet called "Info". Next to each pivot name i woul also like the sheet it is on.

I hope this is possible, if so please help.

Cheers for reading my thread