I have a spreadsheet (around 200k rows) of addresses. The spreadsheet is sorted by ZIP code.

I need a way for excel to think "there are 5,436 records in the first zip code (let's call it 90210), user wants to break the records with zip code 90210 into 30 separate sheets, meaning the first 181 (rounded down) names in 90210 will go on SHEET 1, the second 181 names in 90210 will go on SHEET 2, and so on until SHEET 30 is reached. Sheet 30 would have the remaining names (considering rounding) so it would likely be larger.

Then, excel would need to move to the next ZIP code (let's call it 90211 - with 2,500 records) and do the same thing, adding those ZIP codes evenly to the sheets outlined above.

I know this is somewhat complicated however I've learned that close to everything is possible in excel - any ideas? Any help is appreciated!