I'm trying to make a spreadsheet to take online orders from clients. I send them a price list, which they complete with their order and every time a client sends an order, it automatically adds a new sheet to the "master" spreadsheet. The added sheet is named with the mail from the client and the time they make the order.
The thing is, I want to sum the totals ordered for each product on the list, but sheets are added all the time, and with non predictable names. I have managed to make a list of the sheets using a script (actually I'm having problems making it update automatically), and then using indirect and sumif. But i have to use a sumif for every sheet in the list, and then again the number of sheets may variate. For example I use
=sumif(indirect(E5&"!B$5:B"),B$2,indirect(E5&"!F$5:F"))
where in E5 is the name of the first sheet of the list. Is there a way to use an array formula to aply the sumif formula, to all the sheets in the list? (The list will be in the E column)?