Hi,

I have about 10 sheets in my workbook which contains identical lists of data sorted in columns. The structure is identical between the sheets, and I have ppl responsible to add data to each sheet.

Now I want to consolidate all lists into one large list in a separate sheet, and I want it to automatically gather data from the different lists.

Anyone have any idea where to start with this? I do know how to consolidate data, but I don't wan't to manually mark the list every time where there has been data added.

Thanks in advance for any tips or pointers.