are you saying you have multiple files with worksheets and you want to combine them into a single workbook (file)? If you have them all open you can literally drag the tab from 1 file to the other. Alternatively you can right click on a tab and select Move / Copy and then at the top of that pop up window select the file box and select the other file and where you want to move it to in that other file and repeat for each sheet.
