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...