Listing server contents on a self-updating excel spreadsheet

I have a small business' server to manage and everytime a new client registers with us, we create a folder for them on the server. I would like an excel spreadsheet that would list all of the folders on the server, and continuosly update itself. When a folder is created, a new row should be made with the name of that folder, and when an existing folder is deleted, the row with its name on the spreadsheet should too be deleted. How can this be possibly done, if at all?

Thank you for your help,
David.