Looking to Combine multiple Worksheets into one file after applying worksheet to each

Got a task ahead,

I’m looking at applying a worksheet to a folder, taking a simple worksheet with some formulas, and applying it to a folder full of more complex files.

Id want these worksheet to allow the formula to apply and then pull out a row from each file and paste that into a separate Excel file for each building up a data set.

Is this possible? Ive just started to use Knime and cant seem to figure it out.

You can loop through all the files in your folder and load them into KNIME and apply logic with KNIME formulas/nodes on each sheet within the loop

Any info as to how to go about it?

Or a rough start at least?

For reading multiple excel sheets you might want to have a look
e.g here

to get started