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.,).

exec1.PNG

Exec2.PNG

Tags:

Comments