SSIS

Hi everyone i need help, i am trying to import data from excel into MSSQL database,but what i want to accomplish is to read each of the incoming name of the excel spread sheet and create a table based on the name of the incoming spread sheet, and then import that data into the created table, and after that i would like to split that data, so can anyone out there help with the process of creating the table by reading a name of the incoming excel spreadsheet? please please help