Need VBA code to fill roster timing for upcoming days, week or yr, and total hrs of roster

Dear experts

I have roster table for each team, i want fill same table for coming week or fortnight or month

i fix roster for the week time then i scheduled the calendar to coming week and month, i

in dropdown value what i select and click create roster button, it will fill same database accordingly,

one more option i have calculate it calculate total hours of shift from table shift sheet

help on this

thanks