Copying excel sheet content from one sheet to another within current script

I have created two reports using Aris 7.1 One is printing certain attributes of models. Another report is taking data from the newly created report and writing in a template excel that will create a heat map based on macros in the template excel. Now i want just one report that will serve both the purpose. When i try to create this thing i am stuck at a point how data will be read from excel even when it has not been created. We can use WriteReport function only once in the script. Any leads will be highly appreciated. 

Thanks in advance.