Data Export in Individual Tabs in Excel




I was trying to take export in form of .xls where each item in my page selector should get copied to an individual tab in Excel and the tab name should get renamed as that of the page selector. I was able to get individual copies from each page selector in separate tabs by Exporting in Grid view and selecting All Pages option but the renaming of the tabs is where I stuck right now. The tabs are named as Sheet 1, Sheet 2, Sheet 3 and so on after the Export. Let me know if anyone have some suggestions.