Macro to list Directories in various location - per worksheet

[joldfield101]

I would like to index the directories i have on various servers in excel. and ideally have a script/macro i run to update them.

so i have:

\\server1\share1
\\server1\share2
\\server1\share3
\\server2\share1
\\server2\share2
\\server3\share1
\\server3\share2
\\server4\share1


I would like an excel spreadsheet with a tab/worksheet for each location if possible, so i don't have lots of different XLSX files to manage.

i want an excel spreadsheet with a worksheet for each so worksheet1 would be the folder list of the directories in \\server1\share1 listed in column A. Worksheet2 would be a list of the directories in \\server1\share2 listed in column A....etc.....

is this possible?