Stock Labels and info control

[WERNER SLABBERT]

here goes,

i have a workbook with 2 sheets( at this stage. ) i would like to enter all the stock detail in the first into nice neat rows ( like excel does),
and then have the second sheet formulate the label ( to print for the bins ) with the data from the first sheet in certain order.

but in an effort to save paper i would print it 4 labels wide and 6 high on a standard A4 page...

my problem comes with the offset formula.... please tell me there is an easy-errrrr way to do this????

see sample book at below link.

Thank you in advance...

https://mega.nz/#!NBNgUa6b!8tvHsc33zKKUZ5zUgkv2VZBReybaNC5v8d_w7leUnzM

please help i beg of you all...