How to have tables embedded into one output file containing multiple sheets

[Lauren_Holmes]

Hello,

I am trying to create 1 output file with 3 sheets - Sheet one is multiple tables (similar to pivots), sheet 2 one table exported not as an excel sheet, sheet 3 a standard excel document. 

I have already created the outputs however i am struggling to put all together - see workflow below. I initially exported as sheets on one excel however when i did this the sheets with the tables on came out as:

I have tried rendering to a temporary excel and these come through as i would like however each are separate documents. Am i able to pull all of these together into one document with 3 sheets? If so, how?

[Lauren_Holmes]

@mceleavey Hiya! Sorry, please could i ask one more thing!

At the point of the workflow after the union the sheet 3 headers are all correctly written - see below: 

However, after it has rendered it is coming out as below: Is there a reason for this?

Many thanks!