The "ForEach Loop" container is what you need to loop through the list of files. When you use this, the container gives you a variable which is the name of the file which you can use as an expression to set the file name for the Excel source for a dataflow. Have a look at topic "Foreach Loop Editor" in Books Online.