Loading multiple sheets on a workbook and renaming them

[mandukes]

Hi need a macro which would browse to a location (local drive) and load multiple sheets on a workbook based on a user selection (single or multiple sheets) of extension (.xlsx only) and rename them in serial order with prefix "D-"

Example : D-1, D-2, D-3 and so on

If there already exist sheets in workbook with the similar name then it would delete the existing ones.

Any help would be highly appreciated.

Thanks

 

[mandukes]

No solution? anyone please help I need this