I am using an Excel workbook to collect a series of data. Each worksheet has data specific to a single group. I want to create a single master list based on the data created on each sheet and remove all the duplicates. Automated is best since the end users I am making this document for may not be able to handle dynamically using the Advanced Filter option.

Example Sheet2 A2:A34, Sheet3A2:A34 needs to create a list on Sheet1