Hi Everyone

I am writting a VBA that refresh a Pivot table then show details on a new sheets.

but it get stuck on getting information from the new sheet.

how can refer to this new sheet that opens up each time new details are shown ?

Thanks