Macro to give locations sequencially

As you plan to print labels, the typical tool would be a MailMerge (built in Word). You just need to use labels not letters as a document type.
And you need your data with *S001A*, *S001B*, *S001C* and so on in single database.
This database would be easy to prepare with Excel.
In A1 I'd write a column name (like "Code") (some header is needed for mailmerge) and then in cell A2 (and copy down as needed) the formula generating codes following your pattern, like:

Formula:

Please Login or Register  to view this content.

I did it for just 4 ABCD but for 6 it could be

Formula:

Please Login or Register  to view this content.

And if you need for instance 6 for S001 but only 4 for S002 then you can generate all with this formula and then copy and paste special as values and remove unneeded rows of data.

Then use this excel file as a source for mailmerge.

I attach to this post the excel file and word document and a sample merged document will be attached to next post (limit of 2 attachnets per post on the forum)

And the output looks like this

Please note that previuos post was edited

PS. And if the number of sublocations is different each location, like:
S001 4 sublocations
S002 6
S003 3
S004 11
and so on, to produce

*S001A*
*S001B*
*S001C*
*S001D*
*S002A*
*S002B*
*S002C*
*S002D*
*S002E*
*S002F*
*S003A*
*S003B*
*S003C*
*S004A*
*S004B*
*S004C*
*S004D*
*S004E*
*S004F*
*S004G*
*S004H*
*S004I*
*S004J*
*S004K*


the easiest (for me) way to generate such a list will be by using Power Query - one of possible codes (mostly clicked-out in interface, except of list creation and concatenation of separate code parts:

Please Login or Register  to view this content.

You may change data in (blue) input table and right-click on ootput (breen) table and refresh it.