using SSIS to obtain data for sql server

I want to extract data from a specific tab in an excel 2003 workbook using SSIS and place the data into sql server 2008 r2 in an automated, scheduled manner.
The following is what I currently do: I receive daily excel 2003 workbooks from my company's main customer to load into a sql server 2008 database r2 standard edition. Right now I am manually copying the data from the worksheet I need to work with and
passing the data to entirely to new worksheet in a new workbook. My company
says that I can not ask the user to change the way we receive the data from
them. The current method is going to stay.
However I am having the following problems I need to work with and I am wondering if you have
any suggestions how to to automate the following steps:
1. There are lots of tabs in the workbook and I always need to go to worksheet in the middle of the workbook to obtain the nformation I am looking for.
2. There are hidden columns that I always have to unhide.
3. For your information, the worksheets are grouped together. However I do not need to ungroup the worksheets to obtain the data I need to work with.
4. Sometimes the workbook I receive from the customer has external links that I need to remove or sometimes I can not use the headers on the columns since sometimes the headers contain invalid characters.

What way would you suggest I follow to accomplish this goal? Can you tell me and/or point me to a reference that will show me how to accomplish this goal?