In your Excel Reader >> "Flow Variables" Menu click the plus sign on the Settings grouping. Set the sheet_name setting to whatever variable you have the sheet name loaded as.

Then on the "File and Sheet" Menu, set your "Select Sheet" to the "By name" bubble. This should adjust the sheet thats read in to whatever is loaded in the loop.