Dynamic Sumproduct using external workbook without it being open

Hello

I have a sumproduct formula that dynamically checks for headers of data to compare if they have certain criteria.

Now this formula works but now I'm trying to make it look for data on a external workbook without it being open, so my customers can just replace the raw data with new data, so I have read a few website on how to make it read external workbook but it displaying #Value and when I close the raw data workbook it keeps showing unable to read file.

Any help on this would be great.