It is better to explain what you want to do more completely. Do you wish to sum the cells in
for type 1? Are A, B, C and D always the same as each other? For the data you included, is the desired result 1200? Does each sheet use columns A through E the same way?
Mod, I'm getting killed by emoticons. Is there a "quick disconnect" on one post or symbol?