I am requesting to have one excel sheet that is able to track down each day with each host at the location they are at the time of 11-12. Everyday is a different location that host may be at. Column A has host name and B have the location they are at for 11-12. I need a tracker for each host to know which station they were at for 11-12. Column B is all the possible locations. I would like to have all 4 sheets be tracked into one sheet of the month so I can add on more days after on my own.

HOST SULLY GAGAN ALI ARIEL ANGEL JONATHAN HASSAN ABDUL MARRY SALINA SHAQ ABDUL GEORGE JOSH DANIEL TAZ JACOB MARRY SELINA OLIVIA MAK ISHA JHON FATIMA 11-12 CAR CAR DNH SA BC SPN XD AF FF JRB RW RW PV PV PV PV PV MDW TB TB 12-1 CS DNH JRB SA BC SPN CAR AF FF CAR XD RW RW PV PV PV PV PV MDW TB TB 1-2 CS SA XD BC SPN CAR JRB FF CAR DNH AF RW RW PV PV PV PV PV MDW BDAY BDAY BDAY BDAY COM BDAY COM BDAY COM TB TB CS FLOATERS FLOATERS FLOATERS BREAKS 2-3 BC AF SPN CAR JRB XD CAR DNH SA FF RW RW PV PV PV PV PV MDW TB TB 3-4 CS SPN FF CAR JRB XD AF DNH SA BC CAR RW RW PV PV PV PV PV MDW TB TB 4-5 CS CAR CAR JRB XD AF FF SA BC SPN DNH RW RW PV PV PV PV PV MDW TB TB 5-6 CS JRB DNH XD AF FF CAR BC SPN CAR SA RW RW PV PV PV PV PV MDW TB TB 6-7 CS XD SA AF FF CAR DNH SPN CAR JRB BC RW RW BDAY BDAY BDAY BDAY BDAY BDAY COM BDAY COM BDAY COM BDAY COM BDAY COM PV PV PV PV PV MDW TB TB CS FLOATERS FLOATERS FLOATERS FLOATERS FLOATERS