I am sorry, but I do believe the problem is well defined. I know that it is possible to do a web query with excel, and I know that it should be able to access a publicly linked dropbox folder, but I don´t know how to extract the list of filenames nor how to update this list.. I have some knowledge about programming in general, but I don´t have much experience with VBA. I reckon that with some hints I would manage to do it myself. All I know is that excel is capable of doing pretty much everything one can think of