All

Seeking some assistance please...

I have a workbook with 14 worksheets that have member numbers (ie each member has a unique number) in each sheet... I would like to make a master list of member numbers on a new sheet.... as the member numbers may change each month this needs to be 'dynamic' for want of a better word....

I have some buttons and vba etc that do other formatting etc, however, I can't figure this one.... I will always be 'looking' at column A in each worksheet with the first 'number' in row 2....

so ideally the VBA would go to each worksheet, copy members numbers from WS1, column A2, and paste in new worksheet at c2. then go to WS2, column A2, and copy and paste below the numbers copied from WS1....or something similar.... I need to end up with a list of Unique Member umbers so duplicates would be removed....

hope I haven't confused the issue with my explanation....

TIA
Shaz0503