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

You'll want to look into 3D functions, assuming you're wanting to gather
sums/counts of data.

--
Best Regards,

Luke M
"nitengale" wrote in message
...
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

Luke - I've tried looking under this already and am stuck. I'm not looking
for sums, but rather a dump of data from multiple spreadsheets into one
"summary" sheet.

"Luke M" wrote:

You'll want to look into 3D functions, assuming you're wanting to gather
sums/counts of data.

--
Best Regards,

Luke M
"nitengale" wrote in message
...
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


.

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

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