Not to step on the toes of @GTO at all, but if you could modify your worksheet that returns the data to how I set it up in the attached workbook you can use a function to return the data and avoid using VBA at all. This may or may not suit your needs, but was just a thought.
Power to VBAExpress!