Hi @k0sa and welcome to the KNIME community forum,
You can use a List Files node and pass the URLs to a Table Row To Variable Loop Start so you can read the files using an Excel Reader (XLS) node and after closing the loop by using a Loop End node, you have all the data inside a single table.
Here is an example:
read_multiple_excel.knwf (36.9 KB)
