Need to average Multiple worksheets into one

[Emanuel Levy]

I have attached a generic sheet that I have 52 copies of one for each week in the year. I need to create a sheet that will show the total calls for each category over a year based on the day

Example I need to go through all 52 sheet and add up the # of calls for Monday, Then Tue, etc up to Friday. I don't know how to do this so I need assistance please.

[NoS]

Is it reasonable to think you actually have 52 workbooks one for each week in the year?
If so, what are they named?

[Emanuel Levy]

Is it reasonable to think you actually have 52 workbooks one for each week in the year?
If so, what are they named?

Yes I have 52 workbooks they are named WEEK 1 2014.xlsx through WEEK 52 2014.xlsx

[NoS]

Emanuel

Not sure what you want can be done with formulas.

Don't know what folder your weekly workbooks are in.
Don't know if all 52 workbooks are already in existence.
Don't know where or what you expect for your results.

Here's a VBA solution that runs slow as molasses but will import your weekly totals into a workbook and from there you can do what ever you like with the information.

You'll need to set the required path in the macro.

Probably not what you wanted but hopefully will be of some value if nothing other than for a look-see.

Good Luck with your project
NoS

[Emanuel Levy]

Emanuel

Not sure what you want can be done with formulas.

Don't know what folder your weekly workbooks are in.
Don't know if all 52 workbooks are already in existence.
Don't know where or what you expect for your results.

Here's a VBA solution that runs slow as molasses but will import your weekly totals into a workbook and from there you can do what ever you like with the information.

You'll need to set the required path in the macro.

Probably not what you wanted but hopefully will be of some value if nothing other than for a look-see.

Good Luck with your project
NoS

NoS thank you. I will look at the macro tomorrow