Try this to see if you get in the right direction.
Open your spreadsheet with your information and also a new spreadsheet (Book 1).
On your original spreadsheet, select a tab, right-click, select move or copy.
In the Move or Copy box, make sure Book 1 is selected and choose before sheet 1.
Select the box for make copy.
If you have more than one tab to move, select all of the tabs before you move them. Once the tabs are in the new spreadsheet, you can manipulate the data to combine the information - copy paste, create pivot tables, naming data and VLOOK up.