Excel summing several worksheets each with several tabs?

Question

I have 4 workbooks with 30 tabs in each one. They are the same template to show how many bills for each carrier is paid each day. I need to add tab 1 of each workbook together to get a grand total, then tab 2 and so on. Each workbook belongs to one person showing their work for the day. Some people pay the same carriers. How is the best way to add all of this information up? Each workbook contains 30 tabs to show each day of the month and each workbook belongs to one employee. I need a grand total for all of the employees by day and then by the month. Can someone please help?????

Answer 1

Actually you have more than option
1- Use Data > consolidate. which is a sum tool to get data from several workbooks in several folders in the same time
2- Use DAta > PivotTable, which is apowerful tool to do it, try it it worth every second you spend on it
3- Use Macros to do it, this could need some powerful users to write a macro to do it for you

Trust me, I am the VBAXLMan

Answer 2

you haven't any longer provided plenty guidance so i visit might desire to make some assumptions. a million. There are 7 worksheets named Sheet a million by Sheet 7. 2. you prefer to chart one fee noted as Sum from each and every worksheet. 3. the fee is in cellular Z26 of each and every. 4. you like a column chart. In a clean worksheet decide on the style A1:B8 decide on Insert > Chart > end In Cells A2 by A8 enter the names of your worksheets (Sheet1, Sheet2, etc.) In cellular B1 enter Sum In Cells B2 by B8 enter =Sheet1!Z26 =Sheet2!Z26 =Sheet3!Z26 etc. decide on the chart, then decide on Chart > area > As new sheet Chart1 decide on the worksheet you entered the guidance in > format > Sheet > cover decide on the chart and make modifications you like via picking Chart > Chart techniques. you additionally can seem at distinctive chart types via picking Chart > Chart style. in case you won't have the ability to work out a thank you to alter the guidance table you entered to fulfill you particular standards, regulate you question to grant a minimum of the spectacular 4 assumptions and that i visit describe a thank you to create the table for them.