Multiple Tab export to Excel

I have a report with 10 tabs. When I have to export the table content to Excel I have to go to each tab and export it. Is there a way to export all 10 tabs with a push of a single button?   Thanks...