If you created using a sheet, you can do it so the second one by right click on the sheet and select duplicate so it will create the same as first one, next for second sheet change the data set to second one.
Modify wherever the changes are required like couple of columns are not same when compared to first one so with some small modifications you can able to achieve what you are expecting.
Hope this helps.
To Replicate without also loosing colour formatting
First make a copy of report 1.
on the copy edit datasource and point to new sheet.
If you now want to merge both reports together jut right click on tab copy from one workbook and paste to other workbook