Creating a DashBoard

[denzil21]

I have a MS-Excel Workbook with 100+ Sheets. I need come up with a dash board like, fetching the information based on Column, C D and Column E and to have a count based on Column E, grouped by per Sheet and all the sheets

Column C Label is ''RACK

Column D Label is 'Device No.'

Column E Label is 'Device Type.'


Additionally Grouped By Column Q, Label 'Location'.

I have altered the read names of the Lables.