Hi,

I have many stocks lists from different supliers (code, barcode, product name, quantity, price etc), and each time I get newer, varies its number of rows. All stocks lists are completely different, there are no interfaces or connection between these lists (except some words in product name). I can compare all goods only with autofilter function. So I need to put stocks lists one after another into one sheet, all product names must to appear in same column.
As I get new lists from same suppliers twice a week, it takes a lot of time to change old ones with newer. Maybe it is solution, when every stock list is in different sheet, and I can see all together in a main sheet? Maybe it will be easier to use some other program? Thank you for all ideas.