Filter String Labels to Unique List on same spreadsheet

Hi All:

I am fairly new to this aspect of Excel. I need to take 1 to 4 ranges of string labels which may appear multiple times, may include empty cells, and use the advanced filter to copy them to a unique list on the same worksheet. i.e. No matter how many times "ABC" shows up I just need it once in the new list. There are numbers in the adjacent cells associated with these labels which will be processed based on the new list of unique labels. I have done this successfully using the Data-->Filter-->Advanced Function. However, I need it to do this automatically if any of the data in the affected columns is changed. So far it looks like I am going to have to use VBA to do this successfully. Any Ideas or suggestions? Thanks in advance for your help.

Regards,

Stu.........