create button, export five report same format to five sheet of one file xls

Hi
Please help me,
I have the form, in this form there is list of value which run query and resulting the report. For example if I have 5 item in list, i have to choose one of then and the query running and the report is print preview.

My question is,
How to export all 5 report to 5 sheet in one excel file.
I know may be the problem in format if I send to excel, but I will fix it in the excel. The most important is, I export the report to excel, each of the report in each of sheet of excel.

Thanks in advance
sorry my english is not good.

I recently had the need to control how MS Access data was exported to excel and I found both these web pages by Microsoft very helpful.

How To Transfer Data from an ADO Recordset to Excel with Automation
http://support.microsoft.com/default.aspx?scid=kb;en-us;246335


Methods for transferring data to Excel from Visual Basic
http://support.microsoft.com/default.aspx?scid=kb;EN-US;247412

Thanks Uncle Gizmo
I only beginner in vb access, may You or other in this forum help me more, with example. I want to create button in Form1, after I click this button, each of all item in combo box need running the report, an each report export to sheet1, sheet2 to excel file (one file). The name of sheet1 is same with the name of item in combo box.

please help.

Thanks