Need VBA to copy first range and paste to next

Dear expertise

Dear experts

i have data table for project dashboard, i want assign project to team accordingly, i want copy and paste same follow-up section

by doing individually, it takes alot of time. i want vba help copy range from cell C9 till end of date in row 9:9 and column till B

i have data from c9 till AL9 copy the data and paste in AM9 in cell AM10 Date(=AL10+1) till range of copy

Mon-Friday set copy to paste same Monday to Friday

Sat and Sun = Day-Off

for e.g

if 4 weeks with data existed ,copy to next 4 weeks mon to fri.

find the attachment