How to modify current looping directory program to include subfolders

I am trying to loop through a directory, "U:\bsides\Quotes\BUYERS GUIDE\", and as it stands, I have to specify the subfolder and since there are 5 that contain "*.xlsx" file extensions, I have to this long list of code, 5X as long as it needs to be, referencing each different subfolder as the path. I have essentially just copy and pasted the same code 5 times, changing the path for each. In the future, there may be more than 5 subfolders, so I was wondering what do I need to add to include the search of subfolders.

Here is the code:

Please Login or Register  to view this content.

This works fine for now, just if I add subfolders, I have to copy and paste more code, and I figured there is probably an easier way to do this.

Just as reference, that "bunch of random formatting and search code" is over 200 lines each.

Thanks, I quickly glanced through it. I might try to incorporate a few lines here and there for code. I will tinker with it tomorrow at work.