VBA Macro: Copy and Paste Specific Row Range based on the Specific Value in a Cell.

Hm, I see.

Say for instance the user wants to extract weekly availability from the main sheet (I've added next week's availability), so for example the main sheet will have command buttons that will extract specific weeks.
As an example, we have "Week 45" and "Week 46" groups in the main sheet and the user first extracts availability for Week 45. Once Week 45 is coming to an end, the user would then extract availability for Week 46, which would replace information in the daily sheets (Sunday Week 45 availability would then get replaced by Sunday Week 46 availability).

Also, I imagine any updates in the main sheet, say for instance someone decides to become unavailable on Monday of whichever week we're working with and then the user extracts the updated data, will the code replace the old data with new data?