As Bryce mentioned you can use DIRPlus() to create your array, it can be found at the link I provided.

In your script you would then run the DIRPlus UDF to create your array of user folders,

Then with that you can use the code that I provided and do a For Each $ in $Array to read the files