I have a folder structure with template files in the folders. I want to
create a named folder (based on a sequential number), all subfolders and
copies of the template files with the same suffix that the top level folder
has (in this case, a -xxx number). I want to do this from a command within
excel, then create a new column based on the new folders (with contract
number/name/filename) and set hyperlinked cells within the new column to the
newly created files. I would also like to password protect the macro/command
to ensure it cannot be accessed accidentally.

Any help greatly appreciated.