Seeking suggestions to auto populate sheet from master

[Nanaia]

I'm trying to find a way to develop production cut sheets based on the data entered on the master for the file. On the master will be up to three sheet sizes, and sheet quantities for each size listed in their own cells (column N is sheet lengths, column P has quantities needed for column N). I'm trying to find a way to pull the data from the master sheet and group in fifty sheets or less. If the required number of sheets from the master exceed 50 sheets, then it needs to subtract the first fifty (sorted from the longest sheet size to the shortest sheet size). For example, if one job needs 20 sheets of 150", 46 sheets of 120", and 9 sheets of 96", I need it to fill in one section until it reaches 50 sheets, then put the remaining sheets in a different section, and keep breaking it down in groups of 50 or less. I've attached a screenshot of a rough draft of the layout. Is this possible or am I dreaming?