Consolidating workbooks

[jpross]

I have a number of identical workbooks that I'd like to "pull" into a new workbook as separate sheets so that I may do some aggregation of data.

Is there an easy way to open a new workbook and "import" the workbooks into separate sheets within the new workbook?

 

[Barry Katcher]

Open the new workbook and insert as many new sheets as you will need. Then, open the first of the individual workbooks, click on the grey square on top of the row headers and to the left of the column headers. This highlights the entire worksheet. Copy to the clipboard and paste to sheet 1, cell A1 in your new workbook. Proceed the same way thru the rest of your workbooks. Should take only minutes.

 

[BigC]

Stop!!
With all due respect to Barry, there is an easier & more beneficial way than the method suggested.
I'm assuming the workbooks you wish to copy from are single sheet workbooks, although it doesn't really matter as the technique would be very similar for multi-sheet workbooks.

Open the target workbook
Open the first source workbook
Point to the sheet tab of the source workbook and right click your mouse
Select "Move or copy .." from the context menu
In the "To Book" field, select the target workbook from the drop-down list
In the "Before Sheet" field, select where you want the new sheet to be located once it is in the target book
Click the "Create a copy" checkbox
Click Ok

The above will create an exact copy (an identical twin) of the source sheet (including page set up settings, formats, etc), and copy it into the target workbook in the location required.

HTH