Sum different cells across multiple sheets

[rps199]

I’m hoping someone can help. I’ve spent too long trying to crack this!

I have several customer data sheets all have the same format.

Column A has part numbers, top row has weeks. wk1, wk2 etc.
The sheet is used to record sales. I want to sum the total sales by part number across all customers for each week on a master sheet

The problem I have is the part numbers are in different cells in column A and some customers have more part numbers, some less.

So I have managed to do this by using consolidate but I need the data to be dynamic as new customers sheets will be added and sales yet to be recorded.

Is this possible?

 

[ashakantasharma]

You can use the formula =SUMIFS to have the sum based on all the criteria as required. You may also share a sample sheet for us to have practical solution on the same.