I have created a macro that copies and pastes info from one
spreadsheet to another in the format the I need.

What I am attempting to figure out now is how can I run this macro on
multiple files. There are about 10 files per day that i need to run
this macro on and the file names will change daily. How can i have
the macro reference the desktop folder that i will store these files
in and run the macro through all files? Is this possible?

Secondly, in the macro, the last step is create an XML file out of the
spreadsheet the macro created. It always stops at this step,
prompting me to name the file. Is there a way to automatically name
the file the contents of a specific cell and save it to a destination?

I would really appreciate anyones help with this. I'm clearly not
very skilled with this, so any help you can offer would be greatly
appreciated :)