Thank you Glenn. Unfortunately I'm not sure the method for selecting a range will work for me. I need to find a way to create a defined range of sheets that can somehow include each new sheet my macro creates, so a dynamic range. I may just need to split my workbook into 4 separate workbooks based on the district, but ideally I could have this all in one sheet. So close!