Hi,

I have 5 sheets in excel workbook.

SheetA
SheetB
SheetC
SheetD
SheetE

I have a dashboard in sheetE for which i am using data from some other sheets.
How do I know from what sheets the data is coming to SheetE. I want to delete other sheets if i am not using them for SheetE dashboard.
Please help.