All you need to do is to loop through the collection of sheets.
DataRow[] sheetsToImport = dtExcelSchema.Rows;
foreach(DataRow r in sheetsToImport)
{
string sheetName = r["TABLE_NAME"].ToString();
cmdExcel.CommandText = "SELECT * From [" + sheetName + "]";
}