Replace tab as new one with same name is imported.

I have the below macro. It imports excel workbooks into my current workbook as an additional sheet. Is there a way for a duplicate sheet with the same name to overwrite and remove the original, rather than add the (2) or (3) after the name? For example, if Robert is already imported, I don't want Robert(2) if it's reimported. I'd like the new Robert to overwrite the original.

In some cases, the sheets I'm importing will be updated through the day and the updated one will need to replace the original.

Please Login or Register  to view this content.

OK, where in my original macro should I insert this?

I've tried different locations, but it's still importing as filename(2)