I can't see a Material column in your sample file (I can see Salesperson)

I am guessing each sheet will be a different column on Summary tab ?
(ie Store 2 will be in C, Store 3 in D and so on and so forth)