Thanks for the continued help!
It is always the simple things....
However, the macro is still not doing what I need it to do. I do not want it to open any new excel file at all; I want the macro to populate the Output Summary sheet in the test2.xls file that is already open NOT open a new excel file called temp.xls and enter the data there. Also the data that is getting transferred is still not formatted right - meaning that all the data for row 2 is still all in cell B2 and it is the same for the other rows as well. I need it to be separated into the different cells as shown on the "What I want it to look like" sheet of the test2.xls file.
Thanks again