Nitengale,
Did you ever figure this out? I'm looking for exactly the same kind of
summary sheet, but can't seem to figure it out either. This doesn't seem
like it should be a difficult task to complete, but I haven't figured out the
formula.

Please let me know if you make any progress.

Thanks...

"nitengale" wrote:

I think I need to specify a little more here -

I'm not looking for a subtotal, but rather to take all the data from all
worksheets and dump it into one without having to copy and paste from each
sheet. For example tab #20 has 5 lines of data - add it to the bottom of a
summary tab that has the data from tabs 1 thru 19.

"nitengale" wrote:

I'm sure this is an easy formula, but I need some help....

I have a workbook where a tab is added with each day's activity. I'm
looking to add a summary page that will pick up the data from all tabs
starting on line 6 of each tab (including additional tabs that may be added).

Any suggestions?

Thanks