Greetingz...

I have a Workbook currently with 8 Sheets. I want to use the last Column of each of these Worksheets as a data source for a list that I want to create. All of the cells in the last Column have formulas, but the result is blank. In fact only a few out of thousands will have a value. The list would be in another Workbook the range where I want to start my list is A13 or whatever is the next empty cell.

Now to my question. Is there a way to make this a dynamic list that will be updated from the list & also the sheets.

Meaning that if I and a value to on of the sheets it will update mylist, & if I then delete it from the list it would delete from the range in the worksheet as well.

If thats not enough is there a way to make sure that the list doesn't have duplicate values.

So any help would be very much appreciated.

Thanks,

d