time table flight schedule

Hey everyone,
Here is a new challenge. So I am trying to build .txt from Excel where data input will give me the following output:

#MONDAY
AB1111,ABC,XXXX,XXXX,YYYYMMDDHHMM,YYYYMMDDHHMM,B38XM,N,N737AB,,,,
#TUESDAY
#WEDENSDAY
#THURSDAY
#FRIDAY
#SATURDAY
#SUNDAY

to explain the codes above. everything in black is fixed and not changing. everything in red should be changed from a drop-down menu
AB1111 = flight number
ABC= Call sign ( this is never changed)
xxxx= ICAO departure (for example, Newyork IATA code airport is JFK, while the ICAO code is KJFK)
xxxx= ICAO arrival ( this is oe will stay fixed)
YYYYMMDDHHMM= today is 3. August 2023 1500 LCL. so the format for this will be 202308031500. there are two of those, one referring to departure, the other one to arrival.
B38MX= aircraft type
N737AB= aircraft registration

depend on-flight frequency, it should appear on which day. so the input, of the drop-down menu will be based on the database I provide.
the menu that I will be generated from, I should provide the start date and end date, and whenever the day of the week falls in should generate that flight as output.


I will be using Google sheet

thank you

Hey,

as this is an Excel forum only and as VBA can't work with Google sheet …