I run a wkly report and currently copy/paste each group of data onto its own separate tab. I would like to know if there is some kind of way to do this in excel. This report consists of data from our 28 locations. I would need to have a tab per location then move each location's data onto its own tab within the same report. Any help or suggestions would be appreciated. Thanks.