RE: Consolidation
Hi Darren
My interpretation of the question you have asked is that you may be looking to one of of two different things, so I have made two suggestions below. If neither of my suggestions answers your question, please post to the forum again and let us know.
You can consolidate data from different worksheets by using the Consolidate feature, which you can find through the Data menu in Excel.
If you wish to put several worksheets that are in different files into the same Excel file, then you can move sheets from one file to another by right-clicking on the sheet tab of the sheet you want to move, then selecting Move or Copy from the menu.
From the To book: dropdown arrow, select the file you wish to move the sheet to. Please note that if you wish to move the sheet to a file you have already created and saved, you will need to have this file open so that the name of that file appears in the dropdown list.
Then click OK.
This should move the sheet to the Excel file you selected using the dropdown arrow.
Thanks for your question
Amanda