Alright, I don't usually post my IT questions on this forum but I'm hoping this could be a system I could share with other independents to digitally archive all our info and help them look a little less like a mom and pop shop. I also have an easy to print price tags for frames and sales receipts that come out of a printer instead of hand a written one a plumber would give you...and all without having to buy any bloatware/software.

MY NEED:

I have a folder on a shared network drive with excel and pdf files; they're both in the format of LastName_FirstName_PhoneNumber.xls and LastName_FirstName_PhoneNumber.pdf

I'm trying to automate it where a script can make a folder using all of the excel sheet names and put all the files into that folder everytime something is dropped into the folder.

for example, I have patient files
Smith_Bob_800-555-1212.XLS
Smith_Bob_800-555-1212.PDF

The script would create a folder named Smith_Bob_800-555-1212 and place both the pDF and XLS into that folder.

TIA