Combine multiple excel workbooks into one workbook

Hi,

Hi, I have around 10 separate Excel workbooks contaiing only data in them. The data is from Test, Dev, QA, UAT, PRE-PROD, PROD.....etc environments. I need to combine all 10 workbooks data into one. After combining i need to have the data from the 1st column of each sheet into a new sheet without duplicated data.