Adding the data from multiple workbooks/sheets

[dyexcel]

Hi,

Can you please help me regarding the following excel problem.

I have more than one workbooks with multiple worksheets. They all have data. I need to get the sum of data from each workbook / worksheets with multiple conditions to another master workbook.

For example, the master workbook has accountId, deparmentId and locationId. We have to get the sum of the data from workbook/worksheet using these ids as a condition.

I am trying to use SUMIFS & INDIRECT function, but I couldn't get it work.

Could you please help me how to use above functions in this situation or are there any other way to fix this problem?

Thanks
DyExcel