Copy a range of cells to different sheet depending on which month

So I've searched the internet for many hours but i just cannot find a way to do this. I'm not that advanced with excel and with corona i'm getting extra tasks but i lack knowledge for this one.
I'm not even sure if it needs a macro or just formulas so i'm sorry if this is the wrong thread.
So the intention is that depending on the month the work schedule of the employees gets copied to sheet 2.


Either fully automatic, if excel can detect what month it is, it copies the range of cells to sheet 2. But I was thinking that this will be repeating itself every time you open the file and the file in which this needs to happen is pretty big and full of makros already.
Or if you typ the month in a certain cell in sheet 2 and it will go compare/look it up in sheet 1 so it will know which range of cells to copy.

The range of cells to copy is always equally big, just more rows down.

I hope you can understand what i mean

Can you explain a little more how you currently handle this process?

If its just a matter of looking at a worksheet and determining the month to copy based on a column, then it can be done with a macro.

Example.

Your master list has 300 rows.
Column B is your date value

The macro can be run manually or automatically to take todays date(determine the month) and then go look in Column B for any dates that fall in the month.

Select rows that match and copy and paste as needed.

This can be done. Just need little more context on your source data and how you expect to identify the rows you want to work with.