Hi,

You can combine worksheets by doing following steps.
1--Start the Consolidate Worksheets Wizard. ...
2--Select worksheets and ranges to merge. ...
3--Select the consolidation type. ...
4--Choose how you want to merge sheets. ...
5--Select the destination for the merged data.