Import Data Using SSIS from an Excel Workbook which has Dynamic Sheets Using SSIS

Importing data from excel sheets is not difficult, but what is the sheet names are dynamic. here is a faq written by me for this.