Summary worksheet within a workbook

[nitengale]

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 M]

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

 

[Lee Li Fong]

You can use this formula at the cell of summary tab (Sheet7) =SUM(Sheet1:Sheet6!A1) to sum value at A1 from Sheet1 to Sheet6. When you add new sheet within Sheet1 to Sheet, it will automatically sum value at A1 of new sheet

Blog: http://smartusemicrosoftoffice.blogspot.com

 

[nitengale]

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]

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.

 

[JuneS]

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