Create month selection to put the data in another google sheet

[Wilco_kuis]

Hi guys,

Eacht month 2 or 3 collegue’s have two add customer data to monthly google sheet.
Jan,feb, may etc. I created a dropdown so the can search and add the customer, everything is working. But this is only for one month, is it possible that the first have to select the right month and the dropdown place’s the data in the right month google sheet tab?

And if possible the current views also have to change to the right month.

Or are there other option, how i can fixed this.
Can you point me in the good direction.

already thanks.