To create an automated Staff Scheduling Chart

Hello members,

Good day to you all!

I want your help to create an automated Staff Scheduling chart in Excel for our Aircraft Fuelers. The attached Excel file has three sheets.
1st sheet Air_Schedule: We receive a Flight schedule for the year from all airlines which I have automated to be separated datewise per month to get the daily Flight Schedule.
2nd sheet Fueling: Here, I have calculated the times, when a fueler should be on the ramp and when he is finished fueling, for each flight. (Notes attached in the sheet)
3rd sheet Allocation: This is the sheet where I need your help the most to automate the assigning of fuelers to the flights with respect to Time calculations in Sheet 2 and conditions provided in Sheet 3. I have assigned three fuelers to some flights as an example to show the requirement, But you can change the structure whichever way you like.

All help will be highly appreciated.

Please feel free to ask any questions regarding example.

Thank you.