Spreadsheet: 697903d1601603932-generate-sheet-with-lots-of-variation-testsheet1-12torquay12-
Sheet: Sheet to upload

T Shirt |  | True | Color | White | Size | Small |  |  | 3957 SML WHT |  |  | The only part that needs changing is the number here
 |  |  |  | White |  | Medium |  |  | 3957 MED WHT |  |  | But also generate this whole formula from A1 to A32 over and over again depending how many numbers
 |  |  |  | White |  | Large |  |  | 3957 LG WHT |  |  | are on the stock numbers sheet (in this case I only have the 1st 2, 3957 and 4125)
 |  |  |  | White |  | X Large |  |  | 3957 XL WHT |  |  | So the only thing that changes is the number in black nothing else
 |  |  |  | White |  | XX Large |  |  | 3957 2XL WHT |  |  | This list will grow or shrink depending on the stock numbers
 |  |  |  | White |  | 3XL |  |  | 3957 3XL WHT
 |  |  |  | White |  | 4XL |  |  | 3957 4XL WHT
 |  |  |  | White |  | 5XL |  |  | 3957 5XL WHT
 |  |  |  | Army Green |  | Small |  |  | 3957 SML AG
 |  |  |  | Army Green |  | Medium |  |  | 3957 MED AG
 |  |  |  | Army Green |  | Large |  |  | 3957 LG AG
 |  |  |  | Army Green |  | X Large |  |  | 3957 XL AG
 |  |  |  | Army Green |  | XX Large |  |  | 3957 2XL AG
 |  |  |  | Army Green |  | 3XL |  |  | 3957 2XL AG
 |  |  |  | Army Green |  | 4XL |  |  | 3957 4XL AG
 |  |  |  | Army Green |  | 5XL |  |  | 3957 5XL AG
 |  |  |  | Navy Blue |  | Small |  |  | 3957 SML NB
 |  |  |  | Navy Blue |  | Medium |  |  | 3957 MED NB
 |  |  |  | Navy Blue |  | Large |  |  | 3957 LG NB
 |  |  |  | Navy Blue |  | X Large |  |  | 3957 XL NB
 |  |  |  | Navy Blue |  | XX Large |  |  | 3957 2XL NB
 |  |  |  | Navy Blue |  | 3XL |  |  | 3957 3XL NB
 |  |  |  | Navy Blue |  | 4XL |  |  | 3957 4XL NB
 |  |  |  | Navy Blue |  | 5XL |  |  | 3957 5XL NB
 |  |  |  | Black |  | Small |  |  | 3957 SML BLK
 |  |  |  | Black |  | Medium |  |  | 3957 MED BLK
 |  |  |  | Black |  | Large |  |  | 3957 LG BLK
 |  |  |  | Black |  | X Large |  |  | 3957 XL BLK
 |  |  |  | Black |  | XX Large |  |  | 3957 2XL BLK
 |  |  |  | Black |  | 3XL |  |  | 3957 3XL BLK
 |  |  |  | Black |  | 4XL |  |  | 3957 4XL BLK
 |  |  |  | Black |  | 5XL |  |  | 3957 5XL BLK
T Shirt |  | True | Color | White | Size | Small |  |  | 4125 SML WHT
 |  |  |  | White |  | Medium |  |  | 4125 MED WHT
 |  |  |  | White |  | Large |  |  | 4125 LG WHT
 |  |  |  | White |  | X Large |  |  | 4125 XL WHT
 |  |  |  | White |  | XX Large |  |  | 4125 2XL WHT
 |  |  |  | White |  | 3XL |  |  | 4125 3XL WHT
 |  |  |  | White |  | 4XL |  |  | 4125 4XL WHT
 |  |  |  | White |  | 5XL |  |  | 4125 5XL WHT
 |  |  |  | Army Green |  | Small |  |  | 4125 SML AG
 |  |  |  | Army Green |  | Medium |  |  | 4125 MED AG
 |  |  |  | Army Green |  | Large |  |  | 4125 LG AG
 |  |  |  | Army Green |  | X Large |  |  | 4125 XL AG
 |  |  |  | Army Green |  | XX Large |  |  | 4125 2XL AG
 |  |  |  | Army Green |  | 3XL |  |  | 4125 2XL AG
 |  |  |  | Army Green |  | 4XL |  |  | 4125 4XL AG
 |  |  |  | Army Green |  | 5XL |  |  | 4125 5XL AG
 |  |  |  | Navy Blue |  | Small |  |  | 4125 SML NB
 |  |  |  | Navy Blue |  | Medium |  |  | 4125 MED NB
 |  |  |  | Navy Blue |  | Large |  |  | 4125 LG NB
 |  |  |  | Navy Blue |  | X Large |  |  | 4125 XL NB
 |  |  |  | Navy Blue |  | XX Large |  |  | 4125 2XL NB
 |  |  |  | Navy Blue |  | 3XL |  |  | 4125 3XL NB
 |  |  |  | Navy Blue |  | 4XL |  |  | 4125 4XL NB
 |  |  |  | Navy Blue |  | 5XL |  |  | 4125 5XL NB
 |  |  |  | Black |  | Small |  |  | 4125 SML BLK
 |  |  |  | Black |  | Medium |  |  | 4125 MED BLK
 |  |  |  | Black |  | Large |  |  | 4125 LG BLK
 |  |  |  | Black |  | X Large |  |  | 4125 XL BLK
 |  |  |  | Black |  | XX Large |  |  | 4125 2XL BLK
 |  |  |  | Black |  | 3XL |  |  | 4125 3XL BLK
 |  |  |  | Black |  | 4XL |  |  | 4125 4XL BLK
 |  |  |  | Black |  | 5XL |  |  | 4125 5XL BLK