This should help you to solve this. Let me know if you had any issue dealing with this.

SSIS: How to load multiple excel files into multiple SQL tables?

SSIS: How to loop through Multiple Excel sheets and load them into a SQL Table