Hello. I'm trying to create a spreadsheet which will total call numbers per agent, per month. So, what I would like is the book would have sheets. On each sheet is the agent name. Then, what I want to know is it possible that when I click on the agent's sheet tab at the bottom of the screen, could it then create more sheets under that one for each month? Basically, a tree? Is that possible?
No, the basic structure ofcannot be changed, in the sense that, the parent is the workbook and the child is the worksheet (tab). There is no "sub"-worksheet, or "mini"-worksheet.
I would suggest that you rarely if ever would want that, though ... Because this would make it more and more difficult to display data with formulas involving totals, averages, etc.