Hi Friends, I needed some help with Excel. Is there a way we can generate a list of unique values in one sheet from different sheets. Also is it possible that when a new sheet is added it automatically adds the new sheet data and update the list. I have attached a sample sheet.

It will be a big help as I have been stuck on this for some time and really needed some help with this

It will be a big help as I have been stuck on this for some time and really needed some help with this