Creating Summary table from one workbook to another

This code was posted by Leith Ross from another thread (http://www.excelforum.com/excel-prog...le-sheets.html). It creates a summary sheet from specific cells of the other worksheets in a given workbook (this example grabs the values from cells G5, G6, and G18 from all of the worksheets and creates a summary table of these values).

I'm not that familiar with programming in excel, and I only have a basic working knowledge of VB. When I add code to create a new workbook, that new workbook becomes the "dominant" workbook.

My question is: How can I get this code to create the summary table in a new workbook instead of a new worksheet? (I'm summarizing from a government form that doesn't allow for creating a new worksheet).

I've commented out the code I entered to create the new workbook

Please Login or Register  to view this content.