将数据从单个Excel工作簿中存在的232 excel工作表复制到目标工作表中。行名称和工作表名称应相同

To copy data from 232 excel worksheets present in a single excel workbook into a destination excel worksheet present in the same workbook with the criteria that row name in the destination worksheet should be same as worksheetname.Since while naming a worksheet in an excel file we have restriction in size,so for some worksheet the names are written short but in the destiantion worksheet the names are written in fullform.So for some worksheets the data is not accumulated.How to fix this issue?Please help.I am new to VBATo copy data from 232 excel worksheets present