I presume that each of these folders represents a playlist in your library, and that up until now you've used <Artist> - <Name>.<Ext> as your file naming strategy. Once you've added to content to iTunes it only looks at the metadata in the file so the path to the file no longer has any bearing on playlist membership, and track information comes from the tag rather than the filename and path. My scripts work with content from iTunes, so you select content to process there rather that working in the source folder.
Say, for example, that you wanted to reorganize what is in the Monty Python folder, which I assume corresponds to a Monty Python playlist. You would select that playlist in iTunes, then use Ctrl+A to select all the tracks inside. You would then run one of the scripts. ConsolidateByMoving will move things into the same shape that iTunes would generate, ConsolidateByMovingLong is the same but doesn't have the 40-character max. file or folder name limit that iTunes does, and CustomRenamer allows you to use a custom naming pattern other than the default <Media Folder>\Music\<AlbumArtist>\<Album>\<TrackNumber> <Name> layout the other scripts use.
The script would first ask for confirmation that you want to process the selected number of tracks, and allows for it to run automatically, or for you to give track by track confirmation of each action. You're then asked to edit or confirm the suggested media folder where the tracks are going to be moved to. For reasons discussed elsewhere (see Make a split library portable - Apple Community) I generally recommend this is X:\iTunes\iTunes Media, where X: is the drive hosting your library, but it can be wherever you want all of music files to live.
The script then examines each selected item in turn, calculates the intended path for that item, compares with the current location, and if necessary moves it, doing all the other housekeeping that is necessary to keep the track connected to iTunes (and in turn to any playlists it belongs to etc.) removing emptied folders, moving any folder art, etc. These are all things you can do by hand, but only with great effort.
Right now I see absolutely no benefit for you in using a macro in an Excel spreadsheet to build one layer of a folder structure when it doesn't do any of the other things necessary to move the files or update the library and ensure iTunes can keep working correctly.
iTunes playlists exist in iTunes as part of the iTunes Library.itl database. As long as this is maintained correctly there is no real need to export and reimport playlists. They are potentially useful if you want to use an iTunes list in another application such as Plex, VLC, etc. or a non-Apple device. iTunes has the ability to export playlists in a number of formats, e.g. ,m3u or ,xml. Playlists are text files with a custom extension that denotes their format. You can view them in Notepad, but I suggest Notepad++ is a better tool. It is also what I use to edit my scripts. The .m3u form is smaller and easier to read by eye, the .xml form contains more information, is less easy to read, but it is also possible to backup all of the library's playlists in a single xml file. This is what you get automatically if iTunes is sharing the XML file with other applications or manually by using File > Library > Export Library. Playlists are static and rely on absolute folder paths. If you're going to reorganize the layout of your files any playlists you make now couldn't be reimported after the reorganization because the files will be in different places. I don't currently have a solution for exporting all regular playlists, although it is a task that could be done with a script, and I already have a script that exports a single list, so it would be relatively easy to create an expanded version.
tt2
