I need some help. I have a spreadsheet with like 50+ tabs (created from pivot table, show pages). I now need to take each tab and save it as the tab name in a seperate spreadsheet. So I would like a macro take each tab, save it as the tab name, but leave the original spreadsheet intact. Is this possible? If so can anyone help?