Dynamically reading sheets in an Excel file

Hi.

I am a data scientist apprentice who has just started working with Knime.

I am trying to build a flow to dynamically read all sheets in an excel file using a loop.

I have set the flow variable in the excel reader to sheet which corresponds the differing sheet names in the read excel sheet names node.

The issue I am having is the my flow is reading the first sheet 5 times rather than reading the first sheet, second sheet, third sheet etc.

What I am left with in the end is a table showing my fist sheet unioned 5 times.

Here are some screen shots: