If you have keys then you can try the sumif function on the summary.

otherwise it is probably a matter of creating the sheet with vba.

--
Hope this helps
Martin Fishlock
Please do not forget to rate this reply.


"mr pelser" wrote:

having trouble consolidating the different values from 10 columns on 10
sheets to one neat list on the 11th sheet without having to sort them after
they are compiled. Is there an auto sorting way for consolidating?