Help with filling out cells in worksheet based on values in a different work sheet

[eagle_fox]

Hi Everybody.

I hope someone can help with this.

I'm planing a training camp for my Cadet Group and I would to take the information from my Master Sheet (which Contains Names, Squadron, Age and Rank)

I would like to complete the hut listing based on information in the master sheet.
For exmaple I would like to keep members from the same squadron together (based on 10 members per hut)

This code will then also help with populating flight lists where members of the same rank or grouped together

So Example I have the following

First1	Last1	CDT	Squadron1
First2	Last2	L/CDT	Squadron1
First3	Last3	CDT	Sqaudron2
First4	Last4	L/CDT	Squadron2

<tbody>
</tbody>

So I would like the members from Squadron 1 to be placed in Hut 1 and from squadron 2 to be placed in Hut 2
and I would like the CDT to be placed in i flight and L/CDT in a different flight

Ideally the code should allow mw to set the max. numnber of members per hut
The Code needs to handle approx 150 names, 30 Squadrons and 6 flights (CDT, L/CDT, CPL, SGT, BAND, Officers)

Any help would be great

Thank you