Hi Elaine,
Could you please take a look at the question and responses in the KNIME Community Forum thread below? It’s about merging all Excel sheets within a file into one:
Merge all excel sheets in a file to one - KNIME Analytics Platform - KNIME Community Forum