Hi,

I have a workbook called products and it has 12 sheets(january to December)
All the sheets are identical in their first rows and containing:
Date, Product Name, Price, Quantity.

I want to collect the Product Names from each sheet and import them into a new workbook called inventory.

The number of datas in each sheet are not equal. For example, the first sheet January has 12 differet product names, February has 20 different product names, March doesn't have any product names....

Thanks