Probably the best way would be to copy the required sheets from each folder into a new workbook.
So right click on the sheet tab at the bottom, select "move or copy" sheets, then tick the box that says Create a copy, then pick "New book" from the drop down list etc. Then copy sheets from the other workbook into the new workbook.
If you want to give the book the same name as other books you'll have to store it in a different location of course!
Hope that helps