I'm setting up a webshop and using Excel to put in the products.
I've got seperate workbooks for my 20 product-groups (20 excel documents),
and each group is devided in brands (a min. of 5 brands per product group),
which are in worksheets.

I would like to make a file that import all the data from all the
worksheets, without me having to save each worksheet into a different text
file.
I've tried to copy the data and past it as a link, but when a row is added,
updating the link doesn't add the added row.
I've tried to import from text files, it does add added rows, but I've got
to save all my worksheets as text files.

Can anyone help me out?