And in re-reading your question, are you trying to import data from multiple worksheets of an Excel file into Sql Server?
If so, most of the previous post still applies. Use the Import Wizard to create a package that will load in one of the worksheets. Again, save as a package. Then copy the data flow tasks to load each of the worksheets.
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes