reducing formula size

Thanks for this reponse it was really helpful.

The only issue I have now is that the formula is REALLY SLOW.

I can only assume this is because it is opening and closing the linked file everytime I call the function even though I have the linked files open?

Is there a quicker way to do this? As I am calling this formula ~ 50,000 times in the one spreadsheet.