If two of the workbooks are shared copies of the other, they can be merged by clicking Tools-->Compare-->Merge Workbooks on the master. Else, a VBA macro using Sheets(). Move function will be needed.
Data in multiple worksheets can by consolidated into one table; either as one worksheet, on multiple sheets within the same workbook or in different workbooks. The consolidation is done by applying a summy function, for example – the SUM() function which will create the data in a summary.
Selectsheet to be copied in the desired location in the workbook. Give newname. Select the special process "[102] (*. Xls). Convert XLS can automatically rename , overwrite the newly created sheet(s),