Folders that update

[j_excel]

Hi all

Is it possible to have a spreadsheet that shows names of folders in a place and if a new folder is added then the spreadsheet will add it on there automatically. for example say I had the folder names folder 1, folder 2 , folder 3 and the spreadsheet showed this in a list of some sort, then when i added folder 4 the spreadsheet will now show all 4 folders. any help much appreciated.

Thanks
j_excel