Identify Pivot data from excel tabs

Hi Team,

I have an requirement to perform certain operations only to selected tabs within excel wherein i get Pivot tables defined by source. Consider an input excel with 10 tabs out of which few can have Pivot data. Ask is to identify such sheets >> Unpivot >> do certain transformation and write back to excel.

Transformations can be like metadata comparison viz. Extract Column Header or Table Difference Finder etc. followed by order check etc. Whilst i am working upon this logic, struggling to identify or separate out sheets with Pivot data sent by source.

Can you please suggest a logic to separate out sheets with Pivoting data , assuming Unpivoting followed by my transformation logic can be applied on top of it.

Thanks in advance!