Multiple sheets consolidate in a hierarchical single sheet
We have sales team members having their own sheets to capture their client info and industry-specific potential billings. Please see attachments exec1 and exec2
Is there a way for the Sales Manager to view all of this in a single sheet that is grouped by industries? The fixed objects are Industries. The variables are the client list (ABC, DEF etc.,).