Get data from multiple sheets

[Len Silva]

I have built the attached spreadsheet with help from this group and other sources. Everything is in Tables.
Basically, I write a NAME in Col A of sheet 1 and a macro Sheet1.AddSheet creates a new sheet named NAME, copying the template in Sheet 2.
Sheet1.AddSheet then calls macro AddHyperlink to the names on Sheet 1.
I am quite pleased with myself, it works pretty well.

Now, I would like to create reports from data on all sheets.
For instance, each sheet has Ins Co in cell B2 and Ins payments in Col C. I would like to report income by Ins Company by month from all sheets.
I would like to get the number of sessions (from DOS on each sheet) by week and month.
If someone can help me build the engine, I think I can make it work to extract whatever reports I might need.
This will be about 300 sheets by the end of the year, some may have 1 DOS, others may have 50.
Thanks for all you do,
Len Silva

[mikeTRON]

I would just build another macro to aggregate the data from all of those sheets to ONE data tab, then the reporting will be simple.

[Len Silva]

Thanks Mike, but that is what I need help with. I can pull bits and pieces of VBA from the internet and stumble around until it works, but writing from scratch is beyond my capabilities right now.
A macro to do that for all sheets that contain the appropriate data would be a great help.

Thanks,