Given that my excel skills are limited at present, I have a task for work
that I hope you can help with.

A series of saved excel files that are based on weeks - Monday to Sunday.
The sheets are arranged with 1st column being a store with various stores
runing down in rows(not each week shows the same sytores however there are
many times where the same store is shown in seperate sorkbooks). The days of
the week are also aranged in columns- Mon, Tue Wed, Thur, etc.

The cells below each day for the store shows total sales .

So the workbook for the week will show the total sales per store per day.

Now I have multiple weeks and want to see what TRENDS store (A) does on
Mondays ONLY and then Tuesday ONLY etc over the many weeks in order to see if
one day is better than another for that store and then repeat for each store
(A) to (L)

Then do for each store and then clusters of stores which make up regions.

Is this possible easily?

Please advise your options and approach for me . I have thought of and tried
consolidate feature but that just added Monday store (A) of week 1 to same
for week 2 etc .

Thanks

Michael