Seicheamh Saincheaptha (uathlíonadh)

Hi, I'm trying to create a series of inventory labels and I can't figure out how to create a custom sequence to do this. I feel like this should be fairly simple..

The number format is Z1 - A1 - R1 - S1 - B1

Z= zone
A= aisle
R= row
S= shelf
B= bin

the highest number it goes to is

Z2 - A2 - R14 - S5 - B5

So I want to set it to move through the ranges automatically. For example: after Z1 - A2 - R1 - S1 - B5, it should go to Z1 - A2 - R1 - S2 - B1

Any help is greatly appreciated. Thanks!