Link below will help you create multiple sheets.. I have used the same method Raunak Suggested in the past and i think its a good work around if cannot use XL 2007 or Csv

http://www.rafael-salas.com/2008/03/ssis-and-dynamic-excel-destinations_01.html]