Macro for grouping & consecutively numbering groups

Good Day-

I'd like to write a macro that will group a long list of data I have, then consecutively number the groups. Not all the groups contain the same number of rows, but they do follow a pattern. For example:

The first 165 rows = "1"
Next 165 rows = "2"
Next 133 rows = "3"

Then there are 6 more groups of 165, a group of 133, then 2 more groups of 165.

Then the entire segment repeats.

I may have to compile this list several times, so I'd prefer to avoid doing it manually if I can.

Any help would be greatly appreciated!