Renamin Tiffs

I hav situation which i need some help on. I have a script which opens a csv file using FSO (of 2 or 3 cols- tiffname, refno, filepath of tiff) and then renames the tiffs according to the csv file e.g.

tiffname ref filepath
123456.tif abcdefg L:clientfolderfolder

the csv also contains duplicate refs (2 tiffs havein same ref ) and at present i have to manually add an increment of 1 to the duplicate filename i.e abcde-1, abcde-2 etc and I have to manually place the script and the csv in each subflder and then run it.

What i would like to do is amend the script below so that I only have to place it in the root folder and the script then goes through each subfolder (reading the path from the csv file) and rename the tiffs. Is this poss? below is the current script I have Code: