Adding multiple spreadsheets

I have a worksheet with colors and materials. Colors make up the colums and material make up the rows with sales data in the cels. I am trying to add all of my colors and material together on one spreadsheet.

I have 5 spreadsheets with different colors and materials and want to make one master spreadsheet with totals of all 5 spreadsheets.

For example I have the color red in leather and on 3 of the 5 spreadsheets I have sales of 10,15,13 so I would want the total sheet to go and look at all 5 spreadsheets and give me a total of 38 for red leather, any idea on the formula? I tried an index match, but it became too long and cumbersome.

Thanks

Attached is the file per your request, thanks.

Your formula is too basic, I know I can sum each column, looking for a formula that will allow me to sort the main page as well as add/delete names with low maintenance. The index match formula I created will work but there seems to be a limit in excel and I am not able to repeat the formula 12 times, but with the index match, I can sort the main page and data integrity remains intact, with your formula the data integrity is compromised.

I figured it out, I used 4 sheets named quarter and totalled the subsequent months in each sheet, on the summary sheet I used INDEX MATCH, I am able to sort, add/delete names, etc,,,,

IF you know of a formula that would work for 12 sheets vs 4 let me know, thanks.