Merge multiple workbook sheet in to one workbook

Hi,

I want to merge multiple workbooks into one workbook, and if any of the sheets have the same name, then the macro should override it or assign a new name or something.

Thanks,