I am not aware of a good way to merge in sheets from multiple workbooks. I know you can loop through the whole sheet and copy cell by cell. I suppose if your format were the same between every sheet you could make that work. You would need to copy formatting from the original sheet and then overlay the copied cells which will only have data. I suppose you could programmatically copy all the formatting cell by cell, but that might be painful.
If PDF is an option, you could just use CFDocument to convert the HTML to PDF and then use CFPDF to append. I'm not sure exactly what you're looking for. Jason
