Sorting numbers into a sequence so that we can print and cut them in the correct order

The Problem:
I print stickers sheets with numbers on and want to be able to print and cut them so that they have the correct numbers on each sheet. (please see PDF attached).
My data merge tool will not allow a cut-collate-stack option (the software is not built to work like that). I have to create a CSV that will assume that role.

I have arranged the numbers in the correct order manually too many times and have decided to stop. Unless there is a solution using a formula in excel.

If you have any suggestions they will be gratefully received.

One final thing - the numbers have to appear in one column only!

Thank you!
N

I have a not-so-pretty solution, but it requires minimal input.

In cell A1, insert your starting number (assuming 1 based on your example).

Cell B2 paste this and drag across:

Please Login or Register  to view this content.

Then in A2 paste and drag across/down as needed:

Please Login or Register  to view this content.

This may be best accomplished with VBA. I was able to get a working version for one of your examples, but it would require maintenance if the format were to change for another sheet format. See attached; the green boxes need to be user inputs of the first value for each sheet.